2
Reply

What command do we use to rename a db?

Dinesh Beniwal

Dinesh Beniwal
19y
6.9k
0
Reply
    Manju lata Yadav
    USE master; GO ALTER DATABASE AdventureWorks2012 Modify Name = Northwind ; GOsp_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 Yadav
    11y
    0
    Dinesh Beniwal
    sp_renamedb ‘oldname’ , ‘newname’
    Dinesh Beniwal
    19y
    0
Message