Refactoring Databases - Evolutionary Database Design

Introduce Cascading Delete

The database automatically deletes the appropriate child records when a parent record is deleted.



Example

Introduce Cascading Delete Example

For more information see page 215 of Database Refactoring