However,

when designing a database you might want to put the objects of different
schemas into different tablespaces. Then you can drop the corresponding
tablespace. Read the SQL-Reference.

yours

Till

Maeve Branigan schrieb:
> 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
>
>

--
Till Kindschus
b+m Informatik AG
Tel.: +49 4340 404-4241, Fax: +49 4340 404-111
http://www.bmiag.de, mailto:t.[Email address protected]


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