Skip to main content

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