DROP SCHEMA ​

Function ​

DROP SCHEMA deletes a schema from the current database.

Precautions ​

Only the schema owner or a user granted with the DROP permission can run the DROP SCHEMA command. The system administrator has this permission by default.

Syntax ​

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

Parameter Description ​

• IF EXISTS

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

• schema_name

  Specifies the name of the schema to be deleted.

  Value range: an existing schema name

• CASCADE | RESTRICT

  • CASCADE: automatically deletes all the objects contained in the schema.
  • RESTRICT: refuses to delete the schema if the schema contains objects. This is the default action.

Examples ​

See Examples in CREATE SCHEMA.

Helpful Links ​

ALTER SCHEMA and CREATE SCHEMA