DROP SCHEMA

Use the DROP SCHEMA command to remove a schema from a database.

Before you can remove a schema, you must remove all its dependent objects (tables, materialized views, etc.).

Syntax

DROP SCHEMA [ IF EXISTS ] [database_name.]schema_name;

Parameter or clause	Description
IF EXISTS clause	Do not return an error if the specified schema does not exist.
database	Specify the name of a database to remove the schema in that database. You can use `SHOW DATABASES` to get a list of all available databases. If you don't specify a database, the specified schema in the default database will be removed.
schema	The name of the schema you want to remove. The default schema is `public`. You can use `SHOW SCHEMAS` to get a list of all available schemas.

This statement removes the rw_schema schema from the rw_db database:

DROP SCHEMA rw_db.rw_schema;

This statement removes the rw_schema schema from the dev database (default database):

DROP SCHEMA rw_schema;

Use this statement if you don't want RisingWave to return an error if the schema you want to remove does not exist:

DROP SCHEMA IF EXISTS rw_schema;