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.