CODEWITHSUNDEEP
t-sqlazureazure-sql-databaserename
Arun Rana
Arun Rana

Reputation: 8606

Rename SQL Azure database?

How can i rename the database in sql Azure?

I have tried Alter database old_name {MODIFY NAME = new_name} but not worked.

Is this feature available in SQL Azure or not?

Upvotes: 75

Views: 42419

Answers (8)

Baqer Naqvi
Baqer Naqvi

Reputation: 6514

The following query worked for me.

USE master;
GO

ALTER DATABASE old_name
MODIFY NAME = new_name;
GO

Upvotes: -1

Ali Sufyan
Ali Sufyan

Reputation: 94

You can easily do it from SQL Server Management Studio, Even from the community edition.

Upvotes: 0

Brett
Brett

Reputation: 2131

Just so people don't have to search through the comments to find this... Use:

ALTER DATABASE [dbname] MODIFY NAME = [newdbname]

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

Upvotes: 136

serendipity07
serendipity07

Reputation: 4324

You can also connect with SQL Server Management Studio and rename it in Object Explorer. I just did so and the Azure Portal reflected the change immediately.

Do this by clicking on the database name (as the rename option from the dropdown will be greyed out)

Upvotes: 28

Robert
Robert

Reputation: 41

I can confirm the 

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

works without connecting to master first BUT if you are renaming a restored Azure database; don't miss the space before the final hyphen

ALTER DATABASE [oldname_2017-04-23T09 -17Z] MODIFY NAME = [newname];

And be prepared for a confusing error message in the Visual Studio 2017 Message window when executing the ALTER command

Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

Upvotes: 1

Abhishek Gupta
Abhishek Gupta

Reputation: 581

It's Very simple for now - Connect to DB via SQL Management Studio and Just rename as you generally doing for DB [Press F2 on DB name]. It will allow you to do this and it will immediately reflect the same.

Upvotes: 5

Orlin
Orlin

Reputation: 308

Connect with SQL Server Management Studio to your Azure database server, right-click on the master database and select 'New Query'. In the New Query window that will open type ALTER DATABASE [dbname] MODIFY NAME = [newdbname].

Upvotes: 7

dimko1
dimko1

Reputation: 872

Please check that you've connected to master database and you not trying to rename system database.

Please find more info here: https://msdn.microsoft.com/en-US/library/ms345378.aspx

Upvotes: 31

Related Questions