Database in MySQL can be dropped using DROP DATABASE statement.
Syntax to Drop Database:
DROP DATABASE databasename
e.g. to drop an existing database test, the below command can be used:
mysql> DROP DATABASE test;
After a database is dropped in mysql, it can be verified whether database got dropped or not. It can be verified using SHOW DATABASES; statement.
What if database does not exist and We try to drop database in MySQL??
If a database does not exist and we try to drop a database then it would give an error saying database does not exist.
mysql> drop database test123;
ERROR 1008 (HY000): Can’t drop database ‘test123’; database doesn’t exist