DROP SCHEMA

Synopsis

DROP SCHEMA [ IF EXISTS ] schema_name [ CASCADE | RESTRICT ]

Drop an existing schema. The schema must be empty.

The optional IF EXISTS clause causes the error to be suppressed if the schema does not exist.

Drop the schema web:

DROP SCHEMA web

Drop the schema sales if it exists:

DROP SCHEMA IF EXISTS sales

Drop the schema archive, along with everything it contains:

DROP SCHEMA archive CASCADE

Drop the schema archive, only if there are no objects contained in the schema:

DROP SCHEMA archive RESTRICT