• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP SCHEMA

DROP SCHEMA

Function

DROP SCHEMA deletes a schema in a database.

Precautions

Only a schema owner or a system administrator can run the DROP SCHEMA command.

Syntax

DROP SCHEMA [ IF EXISTS ] schema_name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified schema does not exist.

  • schema_name

    Specifies the name of a schema.

    Value range: An existing schema name.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes all objects that are contained in the schema to be deleted.
    • RESTRICT: refuses to delete the schema that contains any objects. This is the default.

Do not delete the schemas with the beginning of pg_temp or pg_toast_temp. They are internal system schemas, and deleting them may cause unexpected errors.

NOTE:

A user cannot delete the schema in use. To delete the schema in use, switch to another schema.

Examples

See Examples in CREATE SCHEMA.

Helpful Links

ALTER SCHEMA, CREATE SCHEMA.