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.
NOTICE: Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.
NOTE: The schema currently being used cannot be deleted. To delete it, switch to another schema first.
Examples
See Examples in CREATE SCHEMA.
Helpful Links
Feedback