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;