Share via


Rules for Deleting Tab, RI Builder

The Rules for Deleting tab in the Referential Integrity Builder specifies rules to apply when a record in the parent table is deleted. This builder also has the Rules for Updating tab and the Rules for Inserting tab.

  • Cascade
    Specifies that deletions in the parent table are reflected in the related child tables. If you select Cascade Delete for a relationship, whenever you delete records in the parent table, records in the related child table are automatically deleted.

  • Restrict
    Prevents you from deleting records in the parent table that have related records in the child table. If you select Restrict Delete for a relationship, an attempt to delete records in the parent table generates an error if there are related records in the child table.

  • Ignore
    Allows you to delete records in the parent table, even if there are related records in the child table.

  • Referential Integrity Grid
    Parent Table displays the name of the table in the database relation containing the primary or candidate index.

    Child Table displays the name of the child table in the database relation.

    Update displays the update rules for referential integrity for the relation. Possible values are Cascade, Restrict, or Ignore. You can change the settings by selecting the field, which will present a drop-down list of the choices.

    Delete displays the delete rules for the referential integrity for the relation. Possible values are Cascade, Restrict, or Ignore. You can change the settings by selecting the field, which will present a drop-down list of the choices.

    Insert displays the insert rules for the referential integrity for the relation. Possible values are Cascade, Restrict, or Ignore. You can change the settings by selecting the field, which will present a drop-down list of the choices.

    Parent Tag grid column displays tag name of the index in the Primary or Candidate in the Parent table.

    Child Tag grid column displays the tag name of the index in the child table.

See Also

Referential Integrity Builder | Rules for Inserting Tab | Rules for Updating Tab