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