sp_renamedb

Transact-SQL Reference

Transact-SQL Reference

sp_renamedb

Changes the name of a database.

Syntax

sp_renamedb [ @dbname = ] 'old_name' ,
    [ @newname = ] 'new_name'

Arguments

[@dbname =] 'old_name'

Is the current name of the database. old_name is sysname, with no default.

[@newname =] 'new_name'

Is the new name of the database. new_name must follow the rules for identifiers. new_name is sysname, with no default.

Return Code Values

0 (success) or a nonzero number (failure)

Permissions

Only members of the sysadmin and dbcreator fixed server roles can execute sp_renamedb.

Examples

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

EXEC sp_renamedb 'accounting', 'financial'

See Also

CREATE DATABASE

sp_changedbowner

sp_dboption

sp_depends

sp_helpdb

sp_rename

System Stored Procedures