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, 1392🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...