Overview

DROP SCHEMA [ IF EXISTS ] schema_name

Description

Deletes an existing schema.

  • The schema must be empty.
  • Use the IF EXISTS clause to suppress the exception that is thrown when the schema to be deleted does not exist.

Examples

DROP SCHEMA web;
DROP TABLE IF EXISTS sales;