How to rename a database in SQL Server

In this article, we will see how to rename a database in SQL Server by using QL Server Management Studio or Transact-SQL.

1. Renaming system databases are not allowed.
2. It is best practice to set a database in single user mode to close any open connections.
3. User must be granted ALTER permission on the database which is going to be renamed.

Rename database in SQL Server using SQL Server Management Studio:

1. Set database in single user mode. Use this link to set single user mode on SQL Server

2. In Object Explorer, expand Databases, right-click the database to rename, and then click Rename.

3. Or select on database name and press F2 from your keyboard and enter the new name for the database and press enter.

Rename database in SQL Server by using SQL Statement:

 USE master;
go
--Set single user mode
ALTER DATABASE learning SET SINGLE_USER;
go
--Rename database name
ALTER DATABASE learning modify name=training;
go
--Now multi user mode
ALTER DATABASE training SET MULTI_USER;
GO

Below is screenshot for above SQL statement execution program.