How can we rename a Database with query?

Priya Lakshmi

 Profile Answers by Priya Lakshmi Questions by Priya Lakshmi

• May 25th, 2011

Sp_rename 'old_db_name','new_db_name';

dinu_26

 Profile Answers by dinu_26 Questions by dinu_26

• Nov 11th, 2008

Syntax of renaming the database:sp_renamedb old_database name new_database nameEg:  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

Answer Question  Select Best Answer