The DROP SCHEMA statement deletes a schema from a database. This topic describes its syntax and limits.
Limits
You cannot delete the default public schema.
Syntax
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]The following table describes the parameters.
|
Parameter |
Description |
|
CASCADE |
The system automatically deletes all objects in the target schema, such as tables and functions. |
|
RESTRICT |
Does not delete the schema if it contains any objects. This is the default. |
Example
DROP SCHEMA mystuff CASCADE; -- Replace mystuff with the name of your schema.