Refactoring Databases - Evolutionary Database Design

Introduce Hard Delete

Remove an existing column which indicates that a row has been deleted (this is called a soft delete or logical delete) and instead actually delete the row from the application (e.g. do a hard delete).



Example

Introduce Hard Delete Example

For more information see page 219 of Database Refactoring