DatabasesIntermediate
Cascading Delete
Pronunciationkas-KAY-ding di-LEET
Definition
A database feature that automatically removes child records when their associated parent record is deleted. It ensures data integrity by preventing orphaned records in related tables.
Where you hear it
During database schema design, migration planning, or when configuring ORM relationships.
Examples
We configured a cascading delete so that removing a user automatically deletes their profile settings.
Using a cascading delete simplifies cleanup but can lead to accidental data loss if not used carefully.
Common mistake
Assuming that cascading delete is always the best choice; developers often forget that it can trigger unintended mass deletions across multiple tables if the relationship chain is long.