MS SQL Server – Drop Database

Drop Database

To remove your database from MS SQL Server, use the drop database command. The following two methods can be used for this purpose.

Method 1 – Using T-SQL Script

Following is the basic syntax for removing the database from MS SQL Server.

Drop database <your database name>

Example

To remove the database name ‘Testdb’, run the following query.

Drop database Testdb

Method 2 – Using MS SQL Server Management Studio

Connect to SQL Server and right-click the database you want to remove. Click the delete command and the following screen will appear.

Drop Database

Click OK to remove the database (in this example, the name is Testdb as shown in the above screen) from MS SQL Server.

In this guide, we will learn about the drop database In Ms SQL server command. To know more click here.

This Post Has One Comment

Leave a Reply