Subject | Finding Referential Integrity Constraint |
---|---|
Author | sugi |
Post date | 2004-05-19T06:07:26Z |
Dear All,
Given a TABLE_NAME and a COLUMN_NAME, is there a safe way to find out
whether this column is involved in a referential integrity constraint
(as opposed to a 'normal' data field) ?
Consequently, if the field is indeed involved in a RI constraint, i need
to know the name of the constraint, name of the 'fk' table, and other
columns involved (if this is a multi-column constraint). Is this
possible in firebird 1.5 ?
Thank you very much in advance,
sugi.
Given a TABLE_NAME and a COLUMN_NAME, is there a safe way to find out
whether this column is involved in a referential integrity constraint
(as opposed to a 'normal' data field) ?
Consequently, if the field is indeed involved in a RI constraint, i need
to know the name of the constraint, name of the 'fk' table, and other
columns involved (if this is a multi-column constraint). Is this
possible in firebird 1.5 ?
Thank you very much in advance,
sugi.