How to Rename a Database in SQL Server: A Detailed Guide

To alter a database, once it's created

Code: SQL Server

<span class="pln">
</span><span class="typ">Alter</span><span class="pln"> database </span><span class="typ">DatabaseName</span><span class="pln"> </span><span class="typ">Modify</span><span class="pln"> </span><span class="typ">Name</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="typ">NewDatabaseName</span><span class="pln">
</span>

Alternatively, you can also use system stored procedure

Code: SQL Server

<span class="pln">
   </span><span class="typ">Execute</span><span class="pln"> sp_renameDB </span><span class="str">'OldDatabaseName'</span><span class="pun">,</span><span class="str">'NewDatabaseName'</span><span class="pln">
</span>

Graphically using SQL Server Management Studio (SSMS)

Step 1: Right click on the database name, then press rename.

Step 2: Write New Database Name and Press Enter