Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 CST