Monday, December 29, 2014

How to rename a SQL Azure database?

1. Connect to your Database
2. Select Master Database
3. Type following Query

Syntax:
alter database <old-database-name> modify name = <new-database-name>

Description:
<old-database-name> is your old DB name
<new-database-name> is your new DB name
Note: Don't use single or double quotes around DB Name

Example:
alter database MyStudent modify name = StudentMaster


Your DB name is changed :)

Happy Coding !!

No comments:

Post a Comment