Re: Foreign keys.

From: <jumaga_at_my-deja.com>
Date: Wed, 10 Jan 2001 21:44:17 GMT
Message-ID: <93il3d$in9$1@nnrp1.deja.com>

drop table <tablename> cascade constraints; will drop the table regardless of any foreign key constraints.

Alternatively:
select * from dba_constraints
where table_name = <tablename>
and constraint_type = 'R';

In article <93ik5h$hod$1_at_nnrp1.deja.com>, vdolt_at_my-deja.com wrote:
> Is there a way to find out all the foreign keys pointing to specific
> table? I am trying to drop it, and referential integrity won't let me.
> Thanks.
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 15:44:17 CST