Re: SQL query for foreign keys?

From: Stan Brown <stanb_at_panix.com>
Date: 24 Jul 2001 06:34:57 -0400
Message-ID: <9jjj0h$s0m$1@panix6.panix.com>

In <9jj4n4$gi9$1_at_fermi.tro.net> "Kay Kanekowski" <kkanekowski_at_mindcommerce.de> writes:

>Hi ,

>try this

>SELECT *
> FROM user_cons_columns
> WHERE constraint_name IN
> ( SELECT DISTINCT dt.constraint_name
> FROM user_constraints m, -- table with PK
> user_constraints dt -- table with FK
> WHERE m.table_name = UPPER( '&1' )
> AND m.constraint_name = dt.r_constraint_name );

Thanks very much for the prompt concse reply. Received on Tue Jul 24 2001 - 05:34:57 CDT