js editor
Web development
The Referential Integrity (RI) Builder helps you create a set of rules that control how records are inserted, updated, or deleted in related tables. The RI Builder generates code for these rules as triggers that reference stored procedures. For more information, see How to: Build Referential Integrity Between Tables.
Builder Tabs
- Rules for Updating
- Specifies rules to apply when the key value in the parent table is modified.
- Rules for Deleting
- Specifies rules to apply when a record in the parent table is deleted.
- Rules for Inserting
- Specifies rules to apply when a new record is inserted or an existing record is updated in the child table.
For more information, see Developing Databases and Trigger Usage.