SQL – Rename a database

·

·

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

Your email address will not be published. Required fields are marked *