js editor
Web development
This tab in the Referential Integrity (RI) builder specifies rules to apply when a record in the parent table is deleted.
- 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
- Makes it possible for 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.