DROP SCHEMA

Deletes a schema from the current database.

Syntax

DROP SCHEMA [IF EXISTS] <schema_name> [CASCADE | RESTRICT]

Parameters

Parameter	Description
`<schema_name>`	The name of the schema to delete.
`IF EXISTS`	Prevents an error if the schema does not exist. Without this clause, the statement fails if the schema is missing.
`CASCADE`	Drops the schema and all objects it contains, including tables, views, and aggregating indexes.
`RESTRICT`	Prevents the schema from being dropped if it contains any objects. This is the default behavior.

Examples

Drop an empty schema

DROP SCHEMA staging;

Drop a schema only if it exists

DROP SCHEMA IF EXISTS staging;

Drop a schema and all its objects

DROP SCHEMA analytics CASCADE;

Prevent dropping a schema that contains objects The following statement fails if the analytics schema contains any tables, views, or other objects:

DROP SCHEMA analytics RESTRICT;

CREATE SCHEMA - Create a schema
ALTER SCHEMA - Modify schema properties

DROP LOCATION

DROP TABLE

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Examples

​Syntax

​Parameters

​Examples

​Related commands

Syntax

Parameters

Examples

Related commands