Hello Maxi, Check constraints are table based, not column based.
With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: mailto:firebird-support@yahoogroups.com Sent: Thursday, June 05, 2014 5:52 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Get check constraints info Hi, I need to get a check constraints info, listing column names. I do: SELECT * FROM rdb$triggers trg JOIN rdb$check_constraints chk_k ON trg.rdb$trigger_name = chk_k.rdb$trigger_name WHERE trg.rdb$relation_name = 'SCHEMA_AUTHOR' AND trg.rdb$trigger_type = 1 But I need the column names to which affect. How I have to do the sql? -- Maxi b: http://maxirobaina.tumblr.com t: http://twitter.com/maxirobaina
