Question

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 1

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