Re: Can you drop a primary key constraint?

Martin Drautzburg wrote:
>
> 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.

  Alter table TABLE_NAME
  drop primary key CASCADE;

  that should do the trick.

--
Posted via CNET Help.com
http://www.help.com/