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.

 

--
Maxi

b: http://maxirobaina.tumblr.com
t: http://twitter.com/maxirobaina