Skip to main content

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;

Parameters

Parameter or clauseDescription
IF EXISTS clauseDo not return an error if the specified schema does not exist.
databaseSpecify 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.
schemaThe 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.

Examples

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;

Help us make this doc better!