Re: Stupid newbie question about foreign keys

check out this table, it holds all the constraints for all the tables under the current user.

select * from user_constraints where constraint_type = 'F' and table_name = 'your table name';

chick*nospam*green_at_gtdev.com wrote in message <34ff40bc.87926561_at_news.gtdev.com>...
>I'm really new to this, but what I need is a script which will list
>all of the foreign keys for a table, and what table and column they
>come from.
>
>Can anyone help me with this?
>
>Thanks, Chick Green
>
>chickgreen_at_gtdev.com
Received on Fri Mar 06 1998 - 00:00:00 CET