sp_renamedb System Stored Procedure

Changes the name of a database.

Syntax

sp_renamedb oldname, newname

where

oldname

Is the original name of the database.

newname

Is the new name of the database. Names of objects and datatypes must follow the rules for identifiers.

Remarks

Only the system administrator can change the name of a database. The system administrator must put a database in single-user mode by using sp_dboption before renaming it, and must restore it to multi-user mode afterward.

Example

This example changes the name of the accounting database to financial.

sp_renamedb accounting, financial

Permission

Execute permission defaults to the system administrator.

Table Used

master.dbo.sysdatabases

See Also