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, 1470🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...