SQL Server 2008 R2 contains a system stored procedure named sp_rename that can be used to change table names.
Correct Answer:
Verified
Q4: Database redesign is rarely needed because databases
Q8: EXISTS and NOT EXISTS are actually just
Q12: Database redesign is equally difficult whether or
Q21: The NOT EXISTS keyword will be true
Q23: When using a double nested set of
Q29: Changing table names is complicated by the
Q30: SQL contains an SQL command RENAME TABLENAME
Q34: The use of a double nested set
Q36: Because of the need to know the
Q37: The design produced by reverse engineering may
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents