Multiple choice technology databases

Is it possible to rename a database and database objects in SQL Server 2005?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Server 2005 supports renaming databases and database objects through the sp_rename system stored procedure. This procedure can rename tables, views, stored procedures, indexes, columns, and other user-created objects. However, some system objects and certain object types have restrictions on renaming.

Keep practicing — related questions