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

From: Richard Willemsen <rwillems_at_xs4all.nl>
Date: Sat, 13 Jun 1998 22:55:18 GMT
Message-ID: <35830320.6843182@192.168.0.1>

Hi,

On Fri, 12 Jun 1998 20:19:14 GMT, - haven - <haven_at_havenskys.com> wrote:

>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;

SQL> drop table emp_head cascade constraints;

>drop table emp_head
> *
>ERROR at line 1:
>ORA-02266: unique/primary keys in table referenced by enabled foreign
>keys
>

grtnx,
Richard

---

Real programmers don't comment their code. It was hard to write, it should be hard to understand.

---

Richard Willemsen
http://www.xs4all.nl/~rwillems/ Received on Sat Jun 13 1998 - 17:55:18 CDT