doc/user/content/sql/drop-database.md
DROP DATABASE removes a database from Materialize.
{{< warning >}} DROP DATABASE immediately removes all objects within the
database without confirmation. Use with care! {{< /warning >}}
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. |
You can use either of the following commands:
DROP DATABASE my_db;
DROP DATABASE my_db CASCADE;
DROP DATABASE my_db RESTRICT;
DROP DATABASE IF EXISTS my_db;
The privileges required to execute this statement are:
{{% include-headless "/headless/sql-command-privileges/drop-database" %}}