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

For more information see page 219 of Database Refactoring