Well, thank you Larry Ellison for "drop user <username> cascade;".

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Maeve Branigan
[mailto:db2udbdba-ezmlmshield-x59322811.[Email address protected]
Sent: Friday, September 24, 2004 5:14 AM
To: LazyDBA Discussion
Subject: RE: How to drop schema?


There is no single command like

"Drop Schema".

you need to remove all of the objects from the schema yourself

-----Original Message-----
From: Kishor Bhede
[mailto:db2udbdba-ezmlmshield-x57009387.[Email address protected]
Sent: 24 September 2004 09:49
To: LazyDBA Discussion
Subject: How to drop schema?


Hello,

I am working in DB2 7.2 on windows, I want to drop
schema present in my Database. Plz tell me how to do
that.

Thanks,

Kishor



_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page