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 2/3)


Rename Database Using MS SQL Management Studio

> First of all Open MS SQL Management Studio And Select your database.
> For Renaming a database, Right Click on the database Icon and select Rename.

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

> Suggest a New Name for your database and press enter.
> By this way we can Rename a database usng Management Studio.

Rename Database Using Code (SQL Script)

> You have two option when Renaming Database using code.
> One is by using Alter Command and another is using Stored Procedure sp_renameDB.
> Alter Command looks likes as follows

> Alter database CurrentDatabaseName Modify Name = NewDatabaseName.

> By Executing the above code we can Rename the Database.
> Second way is by using Stored Procedure sp_renameDB.

> Execute sp_renameDB 'CurrentDatabaseName' , 'NewdatabaseName'.

> By Executing the above Stored Procedure, we can Rename the Database.

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