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, 1378🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...