Re: How to drop PK on more then one table at same time

i'm trying to think of a good reason why one would need to drop a primary key constraint of a table in the first place. just another one of those things that make me go hmmmm...

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:9e1ibu$l9mc$1_at_ID-62141.news.dfncis.de...
>
> "John Smith" <jsmith_at_hotmail.com> wrote in message
> news:MKXM6.239032$Z2.2615561_at_nnrp1.uunet.ca...
> > Is it posible to DROP PK on more then one table at same time eg. ALTER
 TABLE
> > company DROP PRIMARY KEY CASCADE; or i have to write some procedure?
> > Thanks,
> >
> >
> >
> >
>
> Yeah, check the syntax and answer your own question and use your fingers
 to
> write that procedure.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
>
Received on Thu May 17 2001 - 20:12:40 CDT