DROP SCHEMA
DROP SCHEMA
removes a schema from your Materialize instances.
Syntax
Field | Use |
---|---|
IF EXISTS | Do not return an error if the specified schema does not exist. |
schema_name | The schema you want to drop. For available schemas, see SHOW SCHEMAS . |
RESTRICT | Do not drop this schema if it contains any sources or views. (Default) |
CASCADE | Drop all views and sources within this schema. |
Details
Before you can drop a schema, you must drop all sources and views it contains, or use the CASCADE option.
Example
SHOW SOURCES FROM my_schema
my_file_source
DROP SCHEMA my_schema
schema 'my_schema' cannot be dropped without CASCADE while it contains objects
DROP SCHEMA my_schema CASCADE