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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 18 May 2001 00:14:23 +0200
Message-ID: <9e1ibu$l9mc$1@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 - 17:14:23 CDT

This message: [ Message body ]
Next message: Spencer: "Re: How to drop PK on more then one table at same time"
Previous message: John Smith: "How to drop PK on more then one table at same time"
In reply to: John Smith: "How to drop PK on more then one table at same time"
Next in thread: Spencer: "Re: How to drop PK on more then one table at same time"
Reply: Spencer: "Re: How to drop PK on more then one table at same time"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US