You can execute the DROP DATABASE statement to delete a database.

Syntax

DROP DATABASE db_name;         
Note You must delete all the tables in a database before you can delete the database.

Example

use adb_demo2;
+------------------------------+
show tables;
+------------------------------+
| Tables_in_adb_demo2          |
+------------------------------+
| test2                        |
+------------------------------+
drop table test2;
drop database adb_demo2;