Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: foreign keys
Ed Lufker wrote:
> Hi All:
>
> What select statement would I use to see if there are any foreign
> keys on a table.
>
> thanks
> eddie lufker
select * from user_constraints where table_name = upper(table_name);
-- ยบ Michael HsiaoReceived on Tue Mar 03 1998 - 00:00:00 CST