17.16. 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 TABLE IF EXISTS sales