How can I rename a SQL Azure database

Question

Can anyone let me know if there is any way to rename/modify my SQL database name on Azure?
I did try Alter database old_name {MODIFY NAME = new_name} , but it does not work :(
Please let me know if this is the right approach. Thanks in advance.

Answer 1

Don't worry. It is very simple mate!
First, check if the database you've connected to is a master database.
Second, renaming a System databse is not allowed and make sure of that.

Check this link for more information: https://msdn.microsoft.com/en-US/library/ms345378.aspx

Answer 2

ALTER DATABASE [dbname] MODIFY NAME = [newdbname]

(Make sure you include the square brackets around both database names.)

Answer 3

You can use the following command.

ALTER DATABASE [olddbname] MODIFY NAME = [newdbname]

Answer 4

This command serves the purpose

ALTER DATABASE [oldname] MODIFY NAME = [newname];