SQL Server - DROP DATABASE

The SQL Server (Transact-SQL) DROP DATABASE statement is used to drop an existing SQL Server database.

Syntax

The syntax of using DROP DATABASE statement in SQL Server (Transact-SQL) is given below:

DROP DATABASE DatabaseName;

Please note that to drop any database, appropriate privilege is required. Along with this, take extra measures while dropping a database. Deleting a database will result in loss of complete information stored in the database.

After dropping the database, the following statement can be used to see the list of available databases in RDBMS.

SELECT name FROM sys.databases;

Example: drop a database

To drop an existing database with name testDB, the following statement can be used:

DROP DATABASE testDB;

After dropping the database, the below mentioned statement can be used to see the list of databases available in RDBMS.

SELECT name FROM sys.databases;    

This will produce the result which will be similar to:

name        
--------------
SQLExample1 
SQLExample2 
SQLExample3 
SQLExample4 
SQLExample5 
SQLExample6 
SQLExample7 
SQLExample8