how do you drop a primary key(composite of 3 columns)?
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
Subject: [Toad for Oracle - Discussion Forum] 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.