Re: Can you drop a primary key constraint?

From: Steve Long <steven.long_at_erols.com>
Date: Sat, 14 Apr 2001 09:13:15 -0400
Message-ID: <9b9ii6$t3j$1@bob.news.rcn.net>

yes

"nick" <nick-love_at_juno.com> wrote in 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 Sat Apr 14 2001 - 08:13:15 CDT