Sure is - search this mailing list for 'HANDY SCRIPT'

It was about a week ago now...


N.

> -----Original Message-----
> From: sugi [mailto:truesaint@...]
> Sent: Wednesday, 19 May 2004 4:07 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Finding Referential Integrity Constraint
>
>
> 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.
>
>
>
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>