How to drop unnamed unique constraint in oracle?
639823May 17 2008 — edited May 19 2008Hi,
I'm creating a table with unnamed primary key and unique key constraints.
using following script
CREATE TABLE T20 (C01 INT NOT NULL PRIMARY KEY, C02 INT NOT NULL UNIQUE) ;
Now I want to drop the unnamed unique key constraint, I dont want to use the system generated unique key name to drop it.
I can drop primary key constraint but didn't get script to drop unnamed unique key constraint.
plz help me on this...
Thanx,
Ashish