DROP SCHEMA
Remove a schema.
Syntax
Parameters
| Parameter | Description |
|---|---|
IF EXISTS | Do not raise an error if the schema does not exist |
| schema_name | Name of the schema to remove |
CASCADE | Drop the schema and all objects it contains |
RESTRICT | Refuse to drop if the schema contains any objects (default) |
Examples
DROP SCHEMA IF EXISTS analytics CASCADE;