Delete (Drop) A Database Using MS SQL Management Studio

> For Deleting a database, Right Click on the database and select Delete.
> A new window will come as shown below.



> Check the Close Existing Connections and Click OK Button.
> By this way we can Delete a database usng Management Studio.

Delete (Drop) A Database Using Code (SQL Script)

> For Deleting a databse use the following code.
> Alter Command looks likes as follows
> Drop database CurrentDatabaseName.
> If the database is used by some other process, the Delete will not happen.
> First of all close all connections to the database and then do the delete operation.
> If the database is in use, just follow these steps.

> 1. Make the Database in Single User Mode.
> 2. If any transation is happening now, just Rollback them.

> The following code do the above two functions.
> Alter Database DatabaseName Set SINGLE_USER With Rollback Immediate.
> By Executing the above code, we can Delete the Database without having any Error Message.

Watch Video of this Content on Video Streaming