DROP SCHEMA#
Synopsis#
DROP SCHEMA [ IF EXISTS ] schema_name [ CASCADE | RESTRICT ]
Description#
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.
Examples#
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
