Introduce Cascading Delete
The database automatically deletes the appropriate “child records” when a “parent record” is deleted.
Example
For more information see page 215 of Database Refactoring
- Architecture Refactoring
- Structural Refactoring
- Drop Column
- Drop Table
- Drop View
- Introduce Calculated Column
- Introduce Surrogate Key
- Merge Columns
- Merge Tables
- Move Column
- Rename Column
- Rename Table
- Rename View
- Replace LOB With Table
- Replace Column
- Replace One-To-Many With Associative Tables
- Replace Surrogate Key With Natural Key
- Split Column
- Split Table
- Data Quality Refactoring
- Referential Integrity Refactoring
- Transformation
- Method Refactoring
- Parameterize Methods
- Remove Parameter
- Rename Method
- Reorder Parameters
- Replace Parameter with Explicit Methods
- Consolidate Conditional Expression
- Decompose Conditional
- Extract Method
- Introduce Variable
- Remove Control Flag
- Remove Middle Man
- Replace Literal with Table Lookup
- Replace Nested Conditional with Guard Clauses
- Split Temporary Variable
- Substitute Algorithm
Unless otherwise noted, all material on this site is copyright Pramod Sadalage. Please link freely to this site, but if you want to copy any of the materials you should contact the relevant copyright holders first. Send site feedback to Pramod Sadalage