MySQL Tutorial
DROP is used to delete a whole database.
The MySQL DROP DATABASE statement is used to drop an existing database in MySQL schema.
The DROP statement destroys the objects like an existing database, table, index, view or all components in database.
DROP DATABASE database_name;
Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!
DROP DATABASE first_db;
Once a database is dropped, you can check it in the list of databases with the following SQL command:
SHOW DATABASES;