technomark.in
Hot News

$(this) Selector And Children / Find In jQuery

Detect An Undefined Object Property In JavaScript

Rotate And Save Video Using VLC Media Player

Capitalize The First Letter Of String In JavaScript

Convert Any Files To Any Format Using VLC Media Player

Asp.Net AngularJS WCF IIS
DataBase Jquery Bikes Random
HomeContact Us Watch Our YouTube Channel ..........Blog Spot..........

Technomark.in

How To Logout From All Devices In Skype

Technomark.in

How To Embed Google Map In Your Code

Technomark.in

How To Install IIS (Internet Information Services) On Windows

Technomark.in

Enable Directory Browsing In IIS

View All


How To Create, Rename, Delete (Drop) A Database In MS Sql (Part 3/3)


Delete (Drop) A Database Using MS SQL Management Studio

How To Create, Rename, Delete (Drop) A Database In MS Sql, How To Delete A Database In MS Sql, Delete A Database Using SQl Management Studio, Delete A Database In Asp.Net MVC, Asp.Net, MVC, MS SQL

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

How To Create, Rename, Delete (Drop) A Database In MS Sql, How To Delete A Database In MS Sql, Delete A Database Using SQl Management Studio, Delete A Database In Asp.Net MVC, Asp.Net, MVC, MS SQL

> 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

Post Your Comment

Name *


Email *


Comment * Please provide all three fields for posting Comment




Technomark.in

Book Train Tickets on IRCTC Quickly During Tatkal Period

Technomark.in

Before You Copy Any Image From Internet

View All

Privacy StatementDisclaimerSitemap