dineshmaths

 Profile Answers by dineshmaths 

• Nov 3rd, 2008

 

sp_renamedb 'old db name','new db name'

dinu_26

 Profile Answers by dinu_26 

• Nov 11th, 2008

 

Syntax of renaming the database:

sp_renamedb old_database name new_database name



Eg:  name of the database is tree. Now if you need to change the database as three. So the query for changing the database as follows:


sp_renamedb tree three

Priya Lakshmi

 Profile Answers by Priya Lakshmi 

• May 25th, 2011

 

sp_rename 'old_db_name','new_db_name';