Is it possible to rename a database? If so, how would you rename the database?

Email: maixuanviet.com@gmail.com
Skype: maixuanviet.com@outlook.com
Linkein: <a href="https://www.linkedin.com/in/maixuanviet" rel="noopener noreferrer" target="_blank"> linkedin.com/in/maixuanviet
HackerRank: <a href="https://www.hackerrank.com/vietmx" rel="noopener noreferrer" target="_blank"> hackerrank.com/vietmx
Github: github.com/vietmx
Tiktok: <a href="https://www.tiktok.com/@maixuanviet.com" rel="noopener noreferrer" target="_blank"> tiktok.com/@maixuanviet.com

Technology Community › Category: T-SQL › Is it possible to rename a database? If so, how would you rename the database?

VietMX Staff asked 3 years ago

Yes – Databases can be renamed in similar manners as other relational database objects.
- It is possible to rename a database by one of these options:
  - Issue the sp_renamedb system stored procedure.
  - Issue the sp_rename system stored procedure and specify ‘database’ as the parameter.
  - Use Management Studio by right clicking on the database and selecting the ‘Rename’ option.

Question Tags: Junior Level, T-SQL