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 70 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
Excellent


pangili4

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

For a complete list of videos, visit our video library