Re: How to drop Foreign key?

alter table drop constraint <constraint_name>

Primary key is an obvious exception.
If you don't know the name of your constraint select constraint_name
from user_constraints
where constraint_type = 'R'

Hth,

--
Sybrand Bakker, Oracle DBA
Jingyan <jingyan.xu_at_tst2000.com> wrote in message news:SCiX3.647$LK3.24476_at_nuq-read.news.verio.net...
> Hi,
> I use following SQL to drop primary key of T1:
> ALTER TABLE T1
> DROP PRIMARY KEY;
>
> But, I use following SQL to drop Foreign key of T1 and I got a error:
> ALTER TABLE T1
> DROP FOREIGN KEY REFERENCES T2;
>
> Would you like to tell me how to drop it.
> Thanks in advance
> Jingyan Xu
>
>
>
>
Received on Sat Nov 13 1999 - 14:05:40 CST