Re: Can you drop a primary key constraint?

From: Régis Le Bretonnic <rlebretonnic_at_webmail.alten.fr>
Date: Fri, 13 Apr 2001 12:01:12 +0200
Message-ID: <9b6js9$5ao$1@reader1.fr.uu.net>

Not sure that's drop the index.
Check if you have not longer index on your column.

"nick" <nick-love_at_juno.com> a écrit dans le message news: tdcp5m7m9vg67_at_corp.supernews.com...
>
> 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/
Received on Fri Apr 13 2001 - 05:01:12 CDT