How to Delete Database in SQL Server

In this article I am going to explain how to delete in SQL Server.
  • 1943

Introduction

In this article I am going to explain how to delete database in SQL Server. We can delete a database using DROP DATABASE statement. There is another way to delete a database using enterprise manager.

Statement that Delete database

DROP DATABASE emp_record

Steps to delete database in SQL server

Step 1 : Start SQL server :

Clipboard01.jpg

Step 2 : Expend database :

Clipboard02.jpg

Step 3 :  Select database which you want to delete => Right click on selected database => Now click on delete :

Clipboard04.jpg

Step 4 : Delete dialog box appear  to delete database, There are two option, delete backup and restore history information for database and close existing connection :

Clipboard06.jpg

Step 5 : Now we see that emp_record database is deleted and not exist in list of all database :

Clipboard09.jpg


© 2020 DotNetHeaven. All rights reserved.