Presto 337 Documentation

10.19. DROP SCHEMA

10.19. 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