June 26th, 2009

Data Definition Language, DROP SCHEMA

Posted by admin in Q. Data Definition Language

Format:DROP SCHEMA schema_name {RESTRICT | CASCADE};
This command will remove the schema.

If RESTRICT is specified, the schema will not be deleted if all objects in the schema have not been dropped.

If CASCADE is specified, the schema will be deleted with all objects contained in the schema.
Example:

DROP SCHEMA CBT_INC CASCADE;

One Response to ' Data Definition Language, DROP SCHEMA '

Subscribe to comments with RSS or TrackBack to ' Data Definition Language, DROP SCHEMA '.

  1. How I Make $300 a Day Posting Links Online said,
    on June 30th, 2009 at 12:38 pm

    Cool post, just subscribed.

Leave a reply

:mrgreen: :neutral: :twisted: :shock: :smile: :???: :cool: :evil: :grin: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: