sys.sp_renamedb
general #stored-procedure
Description
Changes the name of a database. The current name of the database. follow the rules for identifiers. (success) or a nonzero number (failure). This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. instead.
Syntax
ALTER DATABASE MODIFY NAME