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.

Example

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 SS64.com 1999-2014
Some rights reserved