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
| Field | Use |
|---|---|
| IF EXISTS | 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 | Remove the database and its dependent objects. (Default) |
| RESTRICT | 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.