Select from following answers:- ALTER DATABASE <Old DB Name> RENAME <New DB Name>
- ALTER DATABASE <Old DB Name> ALTER NAME = <New DB Name>
- ALTER DATABASE <Old DB Name> MODIFY NAME = <New DB Name>

- EXECUTE [dbo].[sp_changedbname] '<Old DB Name>', '<New DB Name>'
- All Above
The ALTER DATABASE <Old DB Name> MODIFY NAME = <New DB Name> syntax is the correct way to rename a database. Alternatively,the [dbo].[sp_renamedb] system stored procedure can also be used.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator