MySQL Drop Database

The Drop DATABASE is used to drop/delete/remove an existing MySQL database. Droping a database will result in loss of complete information stored in the database! An error occurs if the database not exists.

Syntax

DROP DATABASE databasename;

DROP DATABASE Example

The following SQL statement drops the existing database "myDB":

Example

DROP DATABASE myDB;

You can use MySQL Command Line Client to drop a database called "myDB". It will look like this:

Note: In order to create database, you must have admin privilege. 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.

« Previous