Hello Ramesh,
If you see in Oracle there is one stmt to drop Schema
with all the objects which breaks the constraints
also: drop user <username> cascade; # This drop schema
as well.
Any stmt like above? plz.
Kishor
--- Ramesh Bhandaru <ramesh.[Email address protected]
wrote:
> **A LazyDBA.com subscriber has responded to your
> lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this
> email,
> **and removed any attachments, and kept your email
> address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see
> your email address as normal
> **Anything below this line is the original email
> text
>
>
> Hi Bhede,
> Before dropping a schema, all objects that were in
> that schema must be
> dropped themselves or moved to another schema. The
> schema name must be in
> the catalog when attempting the DROP statement;
> otherwise an error is
> returned
> to drop a schema from command line
> DROP SCHEMA <name>
>
> Thanks and Regards,
> ____________________________________________________
> Ramesh Bhandaru
>
>
>
>
>
>
> "Kishor Bhede "
>
<db2udbdba-ezmlmshield-x57009387.[Email address protected]
> 09/24/2004 09:49 AM
> Please respond to Ramesh Bhandaru
>
> To: "LazyDBA Discussion"
> <[Email address protected]
> cc:
> 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
>
>
>
>
>
=====
Regards,
Kishor Bhede
Oracle DBA
0-9822701610
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
DB2 & UDB email list listserv db2-l LazyDBA home page