| Subject | Re: [firebird-support] Get check constraints info |
|---|---|
| Author | Martijn Tonies (Upscene Productions) |
| Post date | 2014-06-05T16:00:35Z |
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!
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Sent: Thursday, June 05, 2014 5:52 PM
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
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
Maxi
b: http://maxirobaina.tumblr.com
t: http://twitter.com/maxirobaina
t: http://twitter.com/maxirobaina