0 votes
in PL/SQL by
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?

1 Answer

0 votes
by

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

Related questions

0 votes
0 votes
asked Oct 30, 2019 in DBMS by rajeshsharma
+1 vote
asked Mar 7, 2021 in PL/SQL by SakshiSharma
...