/ How to Rename SQL Server Database

How to Rename SQL Server Database

Using Alter database command ,you can rename the databaases

1) ALTER DATABASE  OldDBName MODIFY NAME = NewDBName


Using Stored procedure query , you can rename the database


2) EXEC sp_renamedb 'oldDBName', 'newDBName'



3) Using GUI , Rghit Click on old database Name , you can see Rename Option ,then you can rename the database with newDBName.