SELECT * FROM USER_CONSTRAINTS WHERE R_CONSTRAINT_NAME = 'Your Primary key
constraint name'
Alexander Bisset <a-bisset_at_aberdeen-harbour.co.uk> wrote in article
<901102565.9360.0.nnrp-05.9e987879_at_news.demon.co.uk>...
> I wish to truncate a table but I am getting a "ORA-02266: unique/primary
> keys in table referenced by enabled foreign keys" message.
>
> I understand why this is happening what I would like to know is how I can
> get a list of all foreign keys that are referencing the table I want to
> drop. I thought I had disabled all of them but there must be one eluding
me.
>
> Thanks in advance,
>
>
>
Received on Wed Jul 22 1998 - 08:44:34 CDT
