Re: Dropping Objects

From: Ranga Chakravarthi <ranga_at_cfl.rr.com>
Date: Mon, 29 Jan 2001 04:02:48 GMT
Message-ID: <IX5d6.33029$Tl3.6373198_at_typhoon.tampabay.rr.com>


Hi,
1. The command you are looking for is : 'DROP USER <username> CASCADE' This will drop all the objects owned by that user. 2. It will drop all the indexes, constraints and triggers associated with that table.
 The only things that will be invalidated are any packages, functions or procedures refrencing the
dropped table.

"Brandon Duncan" <bduncan_at_pietechnet.com> wrote in message news:94pu66$fuh$1_at_bob.news.rcn.net...
> Hi,
> I actually have two questions.
> One : Is there a command which drops all objects associated with a
> Database/User?
>
> Two : Does the command "DROP TABLE X CASCASE CONSTRAINTS" drop all
> objects associated with the table X (Indexes, Constraints, triggers, ect)
 or
> just the constraints? If it doesn't drop everything, what happens to the
> orphaned objects? If it doesn't drop everything associated with table X,
> how do you drop all objects associated with table X?
>
> Thanks,
>
> Brandon
>
>
>
Received on Mon Jan 29 2001 - 05:02:48 CET

Original text of this message