Rename SQL Azure database?

Question

1 Answer

0 votes

1 answer

asked Jun 18, 2019 in Azure by Tech4ever (20.3k points)

0 votes

1 answer

asked Dec 23, 2020 in Azure by dante07 (13.1k points)

0 votes

1 answer

asked Nov 5, 2020 in Azure by dev_sk2311 (45k points)

0 votes

1 answer

asked Nov 5, 2020 in Azure by dev_sk2311 (45k points)

0 votes

1 answer

asked Nov 4, 2020 in Azure by dev_sk2311 (45k points)

krishnika · Answer 1 · 2020-01-27T07:11:37+0000

Before you start renaming, make sure you're using the master database and not connecting to the system database. System databases can not be renamed.

There are multiple ways to rename an SQL database, you can check them all out in this document.

One of the simplest query commands that can be used to solve your problem is:

ALTER DATABASE [dbname] MODIFY NAME = [newdbname]

And also check out Intellipaat's Azure Course and become an Azure expert