Condividi tramite


Referential Integrity Builder

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