Re: inability to drop table dur to unknown enables FK

From: Gerard H. Pille <ghp_at_skynet.be>
Date: 1997/10/05
Message-ID: <01bcd1b7$509391c0$d51beec3@pcghp>#1/1

Disable is not enough, you have to drop the references.

You can check "all_constraints" for references to the primary or unique keys of the table you want to drop

-- 
Kind reGards,

Gerard
(ghp_at_santens.be; ghp_at_skynet.be)

Yochi Wieman <ordnkv_at_shani.net> schreef in artikel
<34374301.16DC_at_shani.net>...


> Problem : Inability to drop table due to unknown enables

> FK which references the table.

> 

> Situation : All known FK referencing the table were disable.

> All data in FK tables was deleted.

> Drop table failed due to 'unique/primary key referenced by enabled

> foreign keys'.

> 

> Questions :

> 1. In which table can we find all FK referencing a particular

> table ?

> 2. Does DROP TABLE require dropping all the FK or just disabling

> them is enough ?

> 3. If there is no table with FK references, what do you suggest 

> as a solution to our problem ? :

>

Received on Sun Oct 05 1997 - 00:00:00 CDT