drop-schema.md 1.6 KB
title: "DROP SCHEMA"
description: "DROP SCHEMA removes a schema from Materialize."
menu:
main:
parent: commands
DROP SCHEMA removes a schema from Materialize.
Syntax
{{< diagram "drop-schema.svg" >}}
| 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:
{{< include-md file="shared-content/sql-command-privileges/drop-schema.md" >}}