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
243 views

4 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,120 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
446 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,120 points
534 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,120 points
1,964 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
66 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,360 points
13 views
+1 vote
2 answers
0 votes
1 answer

What OS is Jenkins installed on Azure Virtual Machine?

Under Managed Jenkins there's a section called ...READ MORE

answered Apr 4, 2018 in DevOps & Agile by DareDev
• 6,520 points
25 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
34 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
81 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.