Rename the sql server database

There are couple of options are available to rename the database. 

Option 1 : 

 Rename the "MyDATABASE" to "MyDATABASE_NEW" using sp_renamedb command

 EXEC sp_renamedb 'MyDATABASE', 'MyDATABASE_NEW' 

Option 2:

 Rename the "MyDATABASE" to "MyDATABASE_NEW" using ALTER DATABASE Commnad

USE [master]

GO

ALTER DATABASE [MyDATABASE] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [MyDATABASE] MODIFY NAME = MyDATABASE_NEW

GO

ALTER DATABASE [MyDATABASE_NEW] SET MULTI_USER

GO