Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: foreign keys
Michael Hsiao <michael_at_infocomm.com.tw> wrote in article
<34FB530F.1E2C52F4_at_infocomm.com.tw>...
> select * from user_constraints where table_name = upper(table_name);
try adding
and constraint_type = 'R'; Received on Tue Mar 03 1998 - 00:00:00 CST