Answers for "how to rename a database in sql server"

sql server rename database

ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ;

rename table sql server

USE AdventureWorks2012;   
GO  
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';

alter database name script

USE master;  
GO  
ALTER DATABASE MyTestDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ;
GO  
ALTER DATABASE MyTestDatabaseCopy SET MULTI_USER
GO

how to rename a database in tsql

USE master;
GO
ALTER DATABASE AdventureWorks2012
Modify Name = Northwind ;
GO

how to rename a database in tsql

Using t-sql
ALTER DATABASE [Test] MODIFY NAME = [Test2]