Model a Table Trigger

A Table trigger is SQL or code automatically executed as a result of the modification of data in a Table, to maintain consistent information across the database. In Enterprise Architect, a Table trigger is modeled as a stereotyped operation, but managed as a constraint.

Access     Tools | Database Builder | Click on Table name > Constraints | Right-click | Add New Constraint (Ctrl+N)


A new constraint is added to the Constraints tab, with the default type index. Click on the drop-down arrow and select trigger. See the Help topic Table Triggers for information on defining the new trigger.

To delete a Table trigger you no longer require, right-click on the trigger name on the Constraints tab and select the Delete constraint <name> option. The  trigger is immediately removed.

Learn more