[firebird-support] Get check constraints info

2014-06-05 Thread Maximiliano Robaina maxi_roba...@yahoo.com.ar [firebird-support]
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

Re: [firebird-support] Get check constraints info

2014-06-05 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [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