Open In App

Delete Database in MS SQL Server

Improve
Improve
Like Article
Like
Save
Share
Report

Prerequisite – Introduction of MS SQL Server and Create Database in MS SQL Server

System databases can’t be deleted, only user databases could be deleted. Data and log files will automatically be deleted from disk with database deletion.

To delete a database, the below methods could be used –

  1. SQL Server Management Studio.
  2. Transact-SQL.

These are explained as following below.

1. Using SQL Server Management Studio :
To delete a database, connect to an instance of the SQL Server, and then expand that instance.

Expand Databases, select the database which need to be deleted.

Right-click the database which need to be deleted, and then click Delete.

Check delete backup and restore history or close existing connections if required and then click OK.

2. Using Transact-SQL :
To execute DROP DATABASE statement a user must have CONTROL permission on the database.

  • To delete a database :
    USE master ;  
    GO  
    DROP DATABASE Databasename;  
    GO  
  • To delete multiple databases :
    USE master ;  
    GO  
    DROP DATABASE database1, database2, ...;  
    GO

Example :
Let us assume we have created a database “Geekstest” which is no longer required, to delete database :

USE master ;
GO
DROP DATABASE Geekstest;
GO 

Last Updated : 02 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads