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.
caution
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;