Change Database Name

Question

Hi Friends I want to know How to change Database name in SQL Server ?

MuthuMari M · Answer

Hi use this line sp_renamedb 'oldDBName' 'newDBName' pls refer this url http://www.mssqltips.com/sqlservertip/1122/how-to-rename-a-sql-server-database/ thanks If this post is useful then mark it as  Accepted Answer

Jignesh Trivedi · Answer

hi to rename database you have three option. Option 1 :Use the following T-SQL(command to make the database name change0. EXEC sp_renamedb 'oldName' 'newName' OR ALTER DATABASE oldName MODIFY NAME = newName This new command that should be used for SQL Serer 2005 and beyond. Option 2 If you are using SQL Server Management Studio right click on the database name and select the option rename. Option 3 Use the detach and attach feature of SQL Server to detach the database first and when you reattach the database you give the database a different name. This can be done by using the GUI or you can do this by using the following commands: EXEC sp_detach_db 'oldDBName' 'true' EXEC sp_attach_db @dbname = N'newDBName' @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf' @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf' hope this help.

Satyapriya Nayak · Answer

Hi Shubham Supported in SQL Server 2000 and 2005 exec sp_renamedb test test1 Supported in SQL Server 2005 and later version ALTER Database test1 Modify Name=test Thanks