Loading
What command do we use to rename a db?
2 Answers
USE master;
GO
ALTER DATABASE AdventureWorks2012
Modify Name = Northwind ;
GO
sp_renamedb [ @dbname = ] 'old_name' , [ @newname = ] 'new_name'
is second option But Avoid it bcz This feature will be removed in a future version of Microsoft SQL Server.
Use ALTER DATABASE MODIFY NAME instead.
Manju lata YadavPosted Jul 1, 2014, 3:56 AM
sp_renamedb ‘oldname’ , ‘newname’
Dinesh BeniwalPosted Jul 13, 2006, 3:15 AM