| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> How to drop Foreign key?
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 - 13:05:23 CST
 |
 |