SQL Server Tutorial SQL Server Advanced SQL Server Database SQL Server References

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 is given below:

DROP DATABASE DatabaseName;

Please note that to drop any database, admin 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 deleting the database, the following command 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 query can be used:

DROP DATABASE testDB;

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

SELECT name FROM sys.databases;
Result:
+-------------+
| name        |
+-------------+
| SQLExample1 |
| SQLExample2 |
| SQLExample3 |
| SQLExample4 |
| SQLExample5 |
| SQLExample6 |
| SQLExample7 |
| SQLExample8 |
+-------------+

5