SQL - DROP or DELETE Database
The SQL DROP DATABASE statement is used to drop an existing database in SQL Instance .
The basic syntax of DROP DATABASE statement is as shown below
DROP DATABASE DatabaseName;
Ex:-
If you want to delete an existing database <TESTDB>, then DROP DATABASE statement would be as follows:Use Master
Go
Drop DATABASE TESTDB
GO
Note : Make sure before dropping the database always take a backup of existing database (ex , TESTDB)