gif Selecting Cascade Update lets you update (as in edit) a primary key, even though the key is on the one side of a one-to-many relationship and referential integrity is enforced. The updates you make to the primary key will be reflected in related records, which have matching data in the foreign key.

Why cascade delete is bad?

Cascading deletes should not cause unexpected loss of data. If a delete requires related records to be deleted, and the user needs to know that those records are going to go away, then cascading deletes should not be used.

How does on Cascade work?

“Cascade” means “When you cast this spell, exile cards from the top of your library until you exile a nonland card whose mana value is less than this spell’s mana value. You may cast that card without paying its mana cost if the resulting spell’s mana value is less than this spell’s mana value.