To rename a database.
1- Connect to the Database Engine.
2- From the Statndard bar, click New Query.
3- Copy and paste the following example into the query window and click Execute. This example changes the name of the AdventureWorks2012 database to Northwind.
USE master;
GO
ALTER DATABASE AdventureWorks2012
Modify Name = Northwind ;
GO
Leave a Reply