Toad World® Forums

drop primary key


#1

how do you drop a primary key(composite of 3 columns)?


#2

ALTER
TABLE
MYTABLE

DROP
PRIMARY
KEY
CASCADE;

This will also drop foreign key constraints that refer back to this primary key constraint.

ALTER
TABLE
MYTABLE

DROP
PRIMARY
KEY;

This will not drop the primary key if foreign key constraint exists which refers back to this primary key constraint.

Neither of these commands will drop the columns from your table. They only drop the constraint.

From: ntesha [mailto:bounce-ntesha@toadworld.com]

Sent: Thursday, March 27, 2014 9:45 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] drop primary key

drop primary key

Thread created by ntesha

how do you drop a primary key(composite of 3 columns)?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.