Renaming a Database

Creating and Maintaining Databases

Creating and Maintaining Databases

Renaming a Database

In Microsoft® SQL Server™ 2000, you can change the name of a database to be changed. Before you rename a database, you should make sure that no one is using the database and that the database is set to single-user mode. The name of the database can include any characters as long as they follow the rules for identifiers.

To rename a database

Transact-SQL

SQL-DMO

See Also

Using Identifiers