DROP SCHEMA
DROP SCHEMA removes a schema from Materialize.
Syntax
| Field | Use |
|---|---|
| IF EXISTS | Do not return an error if the named schema does not exist. |
| schema_name | The schema you want to remove. For available schemas, see SHOW SCHEMAS. |
| CASCADE | Remove the schema and its dependent objects. |
| RESTRICT | Do not remove this schema if it contains any sources or views. (Default) |
Details
Before you can drop a schema, you must drop all sources and views it contains, or use the CASCADE option.
Example
Remove a schema with no dependent objects
SHOW SOURCES FROM my_schema;
my_file_source
DROP SCHEMA my_schema;
Remove a schema with dependent objects
SHOW SOURCES FROM my_schema;
my_file_source
DROP SCHEMA my_schema CASCADE;
Remove a schema only if it has no dependent objects
You can use either of the following commands:
-
DROP SCHEMA my_schema; -
DROP SCHEMA my_schema RESTRICT;
Do not issue an error if attempting to remove a nonexistent schema
DROP SCHEMA IF EXISTS my_schema;
Privileges
The privileges required to execute this statement are:
- Ownership of the dropped schema.
USAGEprivileges on the containing database.