SQL Tutorial
SQL Database
SQL References
SQL Examples

SQL DROP DATABASE Statement

The DROP DATABASE statement is used to drop an existing SQL database

The SQL DROP DATABASE Statement

The DROP DATABASE statement is used to drop an existing SQL database.

Syntax

DROP DATABASE databasename;

Note: Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!

DROP DATABASE Example

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

Example

DROP DATABASE testDB;

Tip: Make sure you have admin privilege before dropping any database. Once a database is dropped, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

Test Yourself With Exercises

Exercise:

Write the correct SQL statement to delete a database named testDB.

Start the Exercise

Contact US

Email:

Content:

SQL Tutorial

SQL Database

SQL References

SQL Examples