8.17. DROP SCHEMA

Synopsis

  1. 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 ifthe schema does not exist.

Examples

Drop the schema web:

  1. DROP SCHEMA web

Drop the schema sales if it exists:

  1. DROP TABLE IF EXISTS sales

See Also

ALTER SCHEMA, CREATE SCHEMA