The SQL drop command is used to delete an SQL database. To drop an existing database by using the drop database command the syntax will be as follows:
The syntax to delete a database
drop DATABASE test_db;
Where the drop database command is followed by the database name to be dropped.
Just make sure, you have sufficient privileges to drop an existing database by using the drop command. Also, make sure the database that you are deleting by the drop statement is not active or currently in use.
Also see – Deleting tables from database