How to delete the database in MS SQL Server

To delete the database in MS SQL Server, we use the DROP command . Here are 2 ways to use this command.

Method 1: Use T-SQL Script

Here is the syntax to delete the database in MS SQL Server.

 Drop database

For example, to delete a CSLD named Testdb, you run the query

 Drop database Testdb

Method 2: Use MS SQL Server Management Studio

Connect to SQL Server and right click on the database you want to delete. Select delete and the following screen will appear.

How to delete the database in MS SQL Server Picture 1
Confirm the information to delete the selected database

Select OK to delete the selected database ( Testdb in this example ) from MS SQL Server.

Previous article: How to select a database in MS SQL Server

Next lesson: How to create a copy of data in MS SQL Server

Isabella Humphrey

Update 25 May 2019

You should read it

How to choose a database in MS SQL Server
you can select the database to manipulate in one of the ways below.
How to create a database in MS SQL Server
ways to create user databases on ms sql server.
Ways to log in database on MS SQL Server
below are instructions on how to log into the database on ms sql server.
Manage MS SQL Server with Management Studio
sql server management studio is a tool in sql server if you choose when installing.
Instructions for installing MS SQL Server
this is a step by step guide to installing ms sql server.
Learn about the architecture of MS SQL Server
in the previous articles, you already know briefly about sql server, how to install sql server on the computer. in this section we will learn about the architecture of sql server.