SQL DROP DATABASE Statement

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

DROP DATABASE Syntax

DROP DATABASE database_name;

Important Points

• DROP a database very carefull; check DROP query once before dropping.
• Deleting a database will result in loss of complete information stored in the database.

EXAMPLE: DROP DATABASE

DROP DATABASE employeeDB;

You can check the database list after dropping the databse; with the following SQL command: 'SHOW DATABASES;' in databases list.

SHOW DATABASES Command

SHOW DATABASES;