Cascade Options

Delete the selected record and any dependent records.

For example, if a user is deleted from the USERINFO table, the associated records in the USERPROFILE table are also be deleted.

The key field linking the record in the secondary table is cleared out, but not the entire record in the secondary table.

For example, if you delete a CONTACT record, the HISTORY records associated with that record are not deleted, just the link to that particular record.

When deleting a record, clear out the key field linking the record in a secondary table, but not the record itself. Replace the key field with another ID.

For example, if a user is deleted from the USERINFO table, replace might be used to assign that person’s accounts to someone else

Delete the selected record, but do not delete any dependent records.

For example, if a user is deleted from the USERINFO table, the associated HISTORY records do not change at all.