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
1,912 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
• 58,090 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 11, 2018 in Azure by club_seesharp
• 3,450 points
10,327 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
• 58,090 points
13,653 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
• 58,090 points
13,247 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 9, 2018 in Azure by club_seesharp
• 3,450 points
6,496 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, 2019 in Azure by Archana
• 5,640 points
908 views
+1 vote
1 answer

How to backup Azure SQL Database?

In Azure SQL Database, you can configure ...READ MORE

answered Jan 22, 2020 in Azure by Sirajul
• 59,230 points
22,838 views
0 votes
1 answer

How to create table in Azure SQL Database?

Creating tables in Azure SQL Database: In Object Explorer, ...READ MORE

answered Jan 22, 2020 in Azure by Sirajul
• 59,230 points
33,582 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
967 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
2,360 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP