How can I rename a SQL Azure database?

0 votes

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.

Apr 13, 2018 in Azure by cloudie_crank
• 1,610 points
420 views

4 answers to this question.

0 votes
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
answered Apr 13, 2018 by null_void
• 3,220 points
0 votes

ALTER DATABASE [dbname] MODIFY NAME = [newdbname]

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

answered Aug 20, 2018 by Priyaj
• 56,940 points
0 votes

You can use the following command.

ALTER DATABASE [olddbname] MODIFY NAME = [newdbname]
answered Nov 30, 2018 by Aniket
0 votes

This command serves the purpose

ALTER DATABASE [oldname] MODIFY NAME = [newname];
answered Nov 30, 2018 by Abhinav

Related Questions In Azure

+1 vote
1 answer

Can I rename a Azure Storage Blob?

Though the approach I'm about to share ...READ MORE

answered May 10, 2018 in Azure by club_seesharp
• 3,450 points
1,162 views
0 votes
2 answers

How can I download a .vhd image to my local machine from azure and upload the same to a different azure account?

From the Windows Azure Portal you can ...READ MORE

answered Aug 20, 2018 in Azure by Priyaj
• 56,940 points
3,154 views
0 votes
2 answers

How can I add database connection string to Azure Functions?

The best way to do this is ...READ MORE

answered Aug 17, 2018 in Azure by Priyaj
• 56,940 points
3,674 views
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 8, 2018 in Azure by club_seesharp
• 3,450 points
307 views
0 votes
1 answer

How to calculate the used database space in SQL Azure?

I don't think its possible to find ...READ MORE

answered Mar 5 in Azure by Archana
• 5,560 points
35 views
0 votes
1 answer

Azure Table or SQL Azure for storing app data.

Azure tables are cheaper, simpler and scale ...READ MORE

answered Jul 8 in Azure by Perry
• 17,020 points
38 views
0 votes
1 answer

How can I copy SQL Azure database to a local development server?

There are certain ways to do this: Using SSIS ...READ MORE

answered Jun 26, 2018 in Azure by null_void
• 3,220 points
82 views
+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
259 views