Drop / delete database in sql server /How to drop database in sql server 2008

Introduction:

This article is helps to delete database using sql server in 2008/2008 R2.

Method 1:

DROP DATABASE  DATABASENAME

Example:

USE MASTER

GO

DROP DATABASE  ASP_DOTNET

GO

Method 2:

Step1:

DatabaseàRight ClickàDelete

Step 2:

Please below checkbox Select/Check close existing connections

Click OK.  Now delete database successfully.