Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to drop PK on more then one table at same time
"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 - 17:14:23 CDT