how to rename database in mssql

How to Rename Database in MsSql

 

Syntex

sp_renamedb '<Old DatabaseName>','<New DatabaseName>'

 

Example

sp_renamedb 'Amit','Amit_Kharbanda';
sp_renamedb 'Amit_Kharbanda','Amit' ;