DROP DATABASE

Use the DROP DATABASE command to remove a database from your RisingWave instance.

Before you can remove a database, you must use DROP SCHEMA to remove all its dependent schemas.

DROP DATABASE removes all data in a database and cannot be undone.

Syntax

DROP DATABASE [ IF EXISTS ] database_name;

Parameters

Parameter or clause	Description
IF EXISTS clause	Do not return an error if the specified database does not exist.
database_name	The name of the database you want to remove. You can use SHOW DATABASES to get a list of all available databases.

Examples

This statement removes the rw_db database which contains two schemas, rw_schema and public (default schema):

DROP SCHEMA rw_db.rw_schema;
DROP SCHEMA rw_db.public;
DROP DATABASE rw_db;

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

DROP DATABASE IF EXISTS rw_db;