Change Database Name

To rename a database, use the system stored procedure sp_renamedb. The syntax is as follows:
Sp_renamedb [@ old_name =] 'old _ name', [@ new_name =] 'new _ name'
Example 6-12: change the name of the mydb database to "my DB ".
Exec sp_renamedb 'mydb', 'mydb'
The running result is as follows:
The database name 'my db' has been set.
Note:Before using this command, set the database access option to single user mode and disable the database. After changing the database name, the original database name is still displayed in Enterprise Manager. Only the "databasee" directory folder is selected, and then click "refresh" in the toolbar, the changed database name is displayed only after you refresh the page or restart SQL Server. The database is case-insensitive.