Author Question: What is the process and what are the considerations when changing a table name? What will be an ... (Read 60 times)

tnt_battle · **on:** Jul 7, 2018

What is the process and what are the considerations when changing a table name?

What will be an ideal response?

Question 2

A two-way linked list has links in both directions.

Indicate whether the statement is true or false

aliotak · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

To change a table name, we re-create the table with the new name, copy the data to the new table, and finally drop the old table. Although the process is simple, there are several considerations. First is the problem of a surrogate key, for the existing values must be maintained. This is solved by creating the key as regular field, copying the date, and then converting the column to a surrogate key. Second is the problem of restructuring constrains to make sure they now apply to the new table. Finally any stored procedures, triggers and other application code that applied to the old table must be rewritten to apply to the new table.

Answer to Question 2

TRUE