This topic contains a solution. Click here to go to the answer
« previous next »

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

tnt_battle

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


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


tnt_battle

  • Member
  • Posts: 556
Reply 2 on: Jul 7, 2018
:D TYSM

bblaney

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

The steps in the hearing process. (1) Sound waves enter the outer ear and travel through the ear ... The steps in the hearing process. (1) Sound waves enter the outer ear and travel through the ear ...
How to find the first and second differences for any table of values How to find the first and second differences for any table of values
DOT placarding requirements: Table 1 materials must be placarded in any quantity, and Table 2 ... DOT placarding requirements: Table 1 materials must be placarded in any quantity, and Table 2 ...
Coolest Period Table EVER Coolest Period Table EVER
Handcrafted wooden coffee table Handcrafted wooden coffee table
periodic table periodic table
Video: Krebs cycle : Formation of acetyl coenzyme A and Electron transport chain

For a complete list of videos, visit our video library