DROP SCHEMA Statement (drop_schema_statement) 

The DROP SCHEMA statement (drop_schema_statement) drops a schema.

Syntax

<drop_schema_statement> ::= DROP SCHEMA <schema_name> [<cascade_option>]

Explanation

The current user must be the owner of the schema that is to be dropped.

The metadata of the specified schema is dropped from the database catalog.

If no CASCADE option or the CASCADE option CASCADE was specified, all the database objects that belong to the schema to be dropped are also dropped.

If the CASCADE option RESTRICT was specified and objects still exist that belong to the schema, the DROP SCHEMA statement fails.