DROP SCHEMA¶

Synopsis¶

DROP SCHEMA [ IF EXISTS ] schema_name

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

See Also¶

ALTER SCHEMA, CREATE SCHEMA