Skip to main content
Deletes a database.

Syntax

Deletes the database and all of its objects including tables, views and aggregating indexes. DROP DATABASE [IF EXISTS] <database_name>

Parameters

ParameterDescription
<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.
I