Javatpoint Logo
Javatpoint Logo

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. 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:

Example:

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

It will look like this:

mysql drop database 1

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

Output:

mysql drop database 2

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.

Next TopicMySQL Create Table




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA