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

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 *

$(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

How To Logout From All Devices In Skype

How To Embed Google Map In Your Code

How To Install IIS (Internet Information Services) On Windows

Enable Directory Browsing In IIS

View All