Toad World® Forums

How to drop a full Schema/user?


#1

How can I drop a full schema/user (with all depending TABLEs, VIEWs, OBJECTs)
?

Ben

View this message in context: http://old.nabble.com/How-to-drop-a-full-Schema-user--tp27529750p27529750.html
Sent from the TOAD mailing list archive at Nabble.com.


#2

Very carefully.


#3

You simply choose that user on the schema browser users tab – do a right
hand mouse and choose drop (or choose the drop toolbar icon). It will ask you
things like are you sure, and cascade – cascade means all objects owned by
that schema.


#4

Just drop the user. Do not forget cascade.

And you better know what you are doing.


#5

FIRST DO A FULL BACKUP and STORE THAT BACKUP SOMEWHERE SAFE.

Then follow the advice that Bert and Jeff provided


#6

Hey Ben,

How can I drop a full schema/user (with all depending TABLEs, VIEWs,
OBJECTs)
?

Seriously, I’d start here: http://tinyurl.com/y9e7s8m

GL!

Rich – [TeamT]

Disclaimer: I’ve taken about 10 of those.