DROP DATABASE
DROP DATABASE removes a database from Materialize.
WARNING!
DROP DATABASE immediately removes all objects within the
database without confirmation. Use with care!
Syntax
DROP DATABASE [IF EXISTS] <database_name> [CASCADE|RESTRICT];
| Syntax element | Description |
|---|---|
| IF EXISTS | Optional. If specified, do not return an error if the specified database does not exist. |
<database_name> |
The database you want to drop. For available databases, see SHOW DATABASES. |
| CASCADE | Optional. Remove the database and its dependent objects. (Default) |
| RESTRICT | Optional. If specified, do not remove this database if it contains any schemas. |
Example
Remove a database containing schemas
You can use either of the following commands:
-
DROP DATABASE my_db; -
DROP DATABASE my_db CASCADE;
Remove a database only if it contains no schemas
DROP DATABASE my_db RESTRICT;
Do not issue an error if attempting to remove a nonexistent database
DROP DATABASE IF EXISTS my_db;
Privileges
The privileges required to execute this statement are:
- Ownership of the dropped database.