[firebird-support] Get check constraints info

[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 



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