You can drop/delete/remove a MySQL database easily with the MySQL DROP DATABASE command. It deletes all the tables of the database along with the database permanently. It throws an error, if the database is not available. We can use the IF EXISTS option with the DROP DATABASE statement. It returns the numbers of tables which are deleted through the DROP DATABASE statement. We should be careful while deleting any database because we will loose all the data available in the database.
Syntax:
DROP DATABASE database_name;
Example:
Let's take an example to drop a database name "employees"
DROP DATABASE employees;
It will look like this:
Now you can check that either your database is removed by executing the following query:
SHOW DATABASES;
Output:
Here, you can see that the database "employees" is removed.
