Syntax
Deletes the database and all of its objects including tables, views and aggregating indexes.DROP DATABASE [IF EXISTS] <database_name>
Parameters
| Parameter | Description |
|---|---|
<database_name> | The name of the database to be deleted |
If the dropped database is set as
DEFAULT_DATABASE for any engine, queries on that engine will fail unless a different database is specified or selected. You can change the default database for an engine using the ALTER ENGINE command.