DROP SCHEMA
- Boaz Raufman
Owned by Boaz Raufman
Feb 26, 2019
1 min read
Loading data...
Drops an existing schema.
Syntax
DROP SCHEMA schema_name [RESTRICT|CASCADE]
Description
The default behavior is RESTRICT, which means that the schema drop will fail if the schema is not empty (tables/views/join indexes/range indexes still exists).
To force dropping the schema with all the existing objects in it, use the CASCADE option.
The default schema (def_schema) cannot be deleted.
Example
DROP SCHEMA my_new_schema CASCADE