Re: Dropping Objects
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