rename mssql database code example
Example 1: sql server rename database
ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ;
Example 2: how to rename a database in tsql
Using t-sql
ALTER DATABASE [Test] MODIFY NAME = [Test2]
ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ;
Using t-sql
ALTER DATABASE [Test] MODIFY NAME = [Test2]