DROP SCHEMA
Contents
Syntax
DROP SCHEMA <schema_name> { CASCADE | RESTRICT }
Drop (delete) a schema.
If RESTRICT
is specified and the schema is not empty, an error will be
returned and no action will be taken.
If CASCADE
is specified then schema is dropped including any objects within
it.
Examples
DROP SCHEMA warehouse;