DROP SCHEMA

Description

Deletes a schema from the current database.

Precautions

• Only the owner of a schema or a user granted the DROP permission for a schema has the permission to run the DROP SCHEMA command. If separation of duties is disabled, the system administrator has this permission by default.
• Users except the initial user and O&M administrator cannot drop the schema of the O&M administrator.

Syntax

DROP SCHEMA [ IF EXISTS ] schema_name [, ...];

Parameters

• IF EXISTS

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

• schema_name

  Specifies the schema name.

  Value range: an existing schema name

Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.

Examples

See Examples in section "CREATE SCHEMA."

Helpful Links

ALTER SCHEMA and CREATE SCHEMA