Collections:
Renaming Database Names in SQL Server
How to rename databases in SQL Server?
✍: FYIcenter.com
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 "FyiCenterData" to "FyiCenterComData":
ALTER DATABASE FyiCenterData MODIFY NAME = FyiCenterComData GO The database name 'FyiCenterComData' has been set.
⇒ Database in Use When Renaming a Database in SQL Server
⇐ Creating Databases with Specified Physical Files in SQL Server
2016-11-24, 1096👍, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...