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