alter database name

Question

How to alter database name from test to test1?

see http://stackoverflow.com/questions/1708651/how-can-i-change-database-name-in-mysql — ax., May 20 '10 at 05:47

score 0 · Answer 1 · answered May 20 '10 at 07:48

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

1 Answers1