A Table Is Classified As A Parent Table And You Want To Drop And Re-c

1.	A Table Is Classified As A Parent Table And You Want To Drop And Re-create It. How Would You Do This Without Affecting The Children Tables?
Answer» DISABLE the foreign key CONSTRAINT to the PARENT, DROP the table, re-create the table, enable the foreign key constraint. Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

A Table Is Classified As A Parent Table And You Want To Drop And Re-create It. How Would You Do This Without Affecting The Children Tables?

Answer»

DISABLE the foreign key CONSTRAINT to the PARENT, DROP the table, re-create the table, enable the foreign key constraint.

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.