DROP SCHEMA

Remove a schema from the database.

Syntax
      DROP SCHEMA schema
    
Key
   schema     The schema to drop. 

All objects in the schema must be dropped before the schema is dropped.

Examples

DROP TABLE MySchema.MyTable1;
DROP TABLE MySchema.MyTable2;
DROP SCHEMA MySchema;
GO

"In Europe everything is permanent, and in America everything is provisional. This is the great distinction which, if always kept in mind, will save a great deal of idle astonishment"~ Willian Dean Howells

Related commands

CREATE SCHEMA
ALTER SCHEMA
DROP TABLE
Equivalent Oracle command: DROP TYPE, DROP USER


 
Copyright © 1999-2024 SS64.com
Some rights reserved