Referential Integrity Builder

JavaScript Editor js editor     Web development 



Main Page

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.

See Also

Other Resources

Builders



JavaScript Editor js editor     Web development