How to Delete Database in SQL Server
In this article I am going to explain how to delete in SQL Server.
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
Steps to delete database in SQL server
Step 1 : Start SQL server :
Step 2 : Expend database :
Step 3 : Select database which you want to delete => Right click on selected database => Now click on delete :
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 :
Step 5 : Now we see that emp_record database is deleted and not exist in list of all database :