Answers

Question and Answer:

  Home  MS SQL Server

⟩ How to rename databases in MS SQL Server?

If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax:

ALTER DATABASE database_name

MODIFY NAME = new_database_name

The tutorial example below shows you how change the database name from "GlobalGuideLineDatabase" to "GlobalGuideLine":

ALTER DATABASE GlobalGuideLineDatabase

MODIFY NAME = GlobalGuideLine

GO

The database name 'GlobalGuideLine' has been set.

 137 views

More Questions for you: