Re: How can I get a list of referenced keys?

You can find the information in the SYS.DBA_CONSTRAINTS view. - haven - wrote in message <35818C6E.FDF1F7F7_at_havenskys.com>...
>I need to get drop this table. How can I get a list of referenced keys?
>
>So that I can drop it. I disabled all constraints that refer to it but
>no dice.
>Thanks
>
>Haven
>
>
>SQL> drop table emp_head;
>drop table emp_head
> *
>ERROR at line 1:
>ORA-02266: unique/primary keys in table referenced by enabled foreign
>keys
>
Received on Fri Jun 12 1998 - 15:37:51 CDT