What is MySQL Drop Database??
You can drop/delete/remove a MySQL database easily with the MySQL command. You should be careful while deleting any database because you will lose your all the data available in your 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.Note: All the database names, table names and table fields name are case sensitive. You must have to use proper names while giving any SQL command.