Re: Can you drop a primary key constraint?

SQL> alter table xx1 drop primary key;

will do the trick UNLESS the primary key is referenced by a foreign key of another table. Then you'll have to drop the foreign key(s) too. Received on Thu Apr 12 2001 - 19:42:29 CDT