DROP DATABASE
Syntax
DROP DATABASE database_name;
Description
Drops an existing database. Only the database owner can execute this.
Important DROP DATABASE
cannot be undone. Use it with care!
If your current database is dropped, you must set a new database for the ongoing sessions. See USE.
Arguments
database_name
The name of the database to drop. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.
Examples
Drop a database
The following shows how to drop the database named DemoDB
:
db.public/<no-store># LIST DATABASES;
+------------+-------------+------------+-------------------------------+
| Name | Is Default | Owner | Created At |
+============+=============+============+===============================+
| mydb | true | sysadmin | 2023-08-09 17:14:46 +0000 UTC |
+------------+-------------+------------+-------------------------------+
| DemoDB | false | sysadmin | 2024-07-02 16:24:11 +0000 UTC |
+------------+-------------+------------+-------------------------------+
db.public/<no-store># DROP DATABASE "DemoDB";
db.public/<no-store># LIST DATABASES;
+------------+-------------+------------+-------------------------------+
| Name | Is Default | Owner | Created At |
+============+=============+============+===============================+
| mydb | true | sysadmin | 2023-08-09 17:14:46 +0000 UTC |
+------------+-------------+------------+-------------------------------+
Last updated