DeltaStream
Search
K

DROP SCHEMA

Syntax

DROP SCHEMA schema_name;

Description

Drops a Schema from the current Database. It can only be executed by the Schema owner. A Schema cannot be dropped if it contains any relations.
DROP SCHEMA cannot be undone. Use it with care!

Arguments

schema_name

The name of the Schema to drop. Optionally, a fully qualified Schema name can be provided to drop a Schema from a Database other than the current Database. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Examples

Drop a Schema in the current Database

The following drops the Schema in the current Database demodb:
demodb.public/demostore# LIST SCHEMAS;
Name | Default | Owner | Created at | Updated at
---------+---------+----------+----------------------+-----------------------
public || sysadmin | 2023-01-13T21:38:57Z | 2023-01-13T21:38:57Z
other | | sysadmin | 2023-01-13T21:38:57Z | 2023-01-13T21:38:57Z
demodb.public/demostore# DROP SCHEMA other;
demodb.public/demostore# LIST SCHEMAS;
Name | Default | Owner | Created at | Updated at
---------+---------+----------+----------------------+-----------------------
public || sysadmin | 2023-01-13T21:38:57Z | 2023-01-13T21:38:57Z

Drop a Schema in a specific Database

The following drops the Schema in the specified Database OtherDB:
demodb.public/demostore# LIST SCHEMAS IN DATABASE "OtherDB";
Name | Default | Owner | Created at | Updated at
---------+---------+----------+----------------------+-----------------------
public || sysadmin | 2023-01-13T21:38:57Z | 2023-01-13T21:38:57Z
Other | | sysadmin | 2023-01-13T21:38:57Z | 2023-01-13T21:38:57Z
demodb.public/demostore# DROP SCHEMA "OtherDB"."Other";
demodb.public/demostore# LIST SCHEMAS;
Name | Default | Owner | Created at | Updated at
---------+---------+----------+----------------------+-----------------------
public || sysadmin | 2023-01-13T21:38:57Z | 2023-01-13T21:38:57Z