In order to enforce referential integrity constraints when converting a generalization hierarchy,the ON DELETE CASCAED option should be specified for actions on referenced rows.

Question

Quizplus · Accepted Answer

ON DELETE CASCADE option will ensure that when a row in a table is deleted, all related rows in other tables are also deleted, thereby enforcing referential integrity constraints.

In Order to Enforce Referential Integrity Constraints When Converting a Generalization