This topic contains a solution. Click here to go to the answer

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

tnt_battle

  • Hero Member
  • *****
  • Posts: 556
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

aliotak

  • Sr. Member
  • ****
  • Posts: 326
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




tnt_battle

  • Member
  • Posts: 556
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


6ana001

  • Member
  • Posts: 311
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

For a complete list of videos, visit our video library