MySQL: DROP DATABASE Statement

The exact opposite of CREATE, the DROP statement drops/deletes the provided database in the query. Note that when dropping a DB be careful on which DB you choose to drop a wrong move can result in permanent deletion of DB and its records within it.

Syntax

DROP DATABASE DBName;

Example

DROP DATABASE moon;

The following query dropped/deleted the moon DB we just created in the CREATE statement article.