MySQL Drop Database

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:

mysql> DROP DATABASE database_name;  

Example:

Let's take an example to drop a database name "employees"

mysql> DROP DATABASE employees;  

It will look like this:

drop database

Now you can check that either your database is removed by executing the following query:

mysql> SHOW DATABASES;  

Output:

drop database

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.