Rename a db in SQL

Question

Hi Friends What command do we use to rename a db ?

Chetan Kumar · Answer

Hi Sp_renamedb 'olddbname''newdbname'

Satyapriya Nayak · Answer

http://www.mssqltips.com/sqlservertip/1122/how-to-rename-a-sql-server-database/

nallya · Answer

1) issues these commands ALTER DATABASE yourdatabase MODIFY FILE ( NAME = logical_file_name  FILENAME = 'your-new-file-on-disk.mdf' ) 2) detach the database 3) rename the files on disk 4) re-attach the database again Use this http://www.sourcecodester.com/tutorials/3759/how-rename-sql-server-database-and-database-filename-mdf-file.html http://dbalink.wordpress.com/2008/07/10/how-to-rename-sql-server-2005-database-using-tsql/

Pradip Pandey · Answer

Hi Check this link http://msdn.microsoft.com/en-us/library/aa238879(v=sql.80).aspx http://www.mssqltips.com/sqlservertip/1122/how-to-rename-a-sql-server-database/ Hope it will help.