alter database name [duplicate]

This question already has answers here: How do I quickly rename a MySQL database (change schema name)? (51 answers) 开发者_运维问答 Closed 8 years ago.

How to alter database name from test to test1?

---

If its a SQL Server 2000 or 2005 database use the following T-SQL: command to make the database name change.

EXEC sp_renamedb 'oldName', 'newName'

The new command that should be used for SQL Serer 2005 and beyond is:

ALTER DATABASE oldName MODIFY NAME = newName

For Oracle database see here