2017  Kodetalk | Feedback | Privacy Policy | Terms | About

drop parent table without affecting child table

A table is classified as a parent table and i want to drop and re-create it. How can i do this without affecting the children tables?

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

Answer is