MySQL Drop Database

MySQL Drop Database

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.

Syntax:

  1. DROP DATABASE database_name;

Example:

Let’s take an example to drop a database name “employees”

  1. DROP DATABASE employees;

sql

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

  1. SHOW DATABASES;

sql01

Here, you can see that the database “employees” is removed.