Rename Database

Rumman Ansari   Software Engineer   2023-03-25   5935 Share
☰ Table of Contents

Table of Content:


To alter a database, once it's created

Code: SQL Server


Alter database DatabaseName Modify Name = NewDatabaseName

Alternatively, you can also use system stored procedure

Code: SQL Server


   Execute sp_renameDB 'OldDatabaseName','NewDatabaseName'

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