Rename Database Using SQL Server Management Studio in SQL Server 2008
In this article I describe how to change database name using SQL Server Management Studio.
Introduction
In this article I describe how to change database name using SQL Server Management Studio. There are various approaches to change SQL Server database name. Sometimes condition arises when you need to rename your database like refreshing the development server with current data or while restoring database and at that time you just give a temporary name but after that you need to rename it on your system.
Change database name using SQL Server Management Studio
Step 1
Open SQL Server Management Studio and connect to database engine.
Step 2
In object explorer step down to the Databases node. Select database name whose name you want to change.
Step 3
Right-click a Database name and choose Rename from popup menu.
Step 4
Enter new database name and click OK.