Table Triggers
Triggers are added to tables to enforce a business rule to executed when data in a table is modified.
Add an Trigger to a Table:
In a Database Explorer window, right click the table node in the node tree to which you want to add a trigger.
In the popup menu, click Add Trigger.
Complete the dialog box that appears and click Ok.
Editing a Trigger:
In a Database Explorer window, click on the Tables node in the node tree.
Select the tree node representing the table containing the trigger to edit.
Now select the Triggers node in the node tree.
A grid of this table's Triggers will be shown in the lower right of the Database Explorer window.
You can type directly into this grid to modify the trigger's definitions. Double clicking a row in the grid allows modification of the Trigger through a dialog window.
Triggers can be removed by selecting the appropriate row(s) in the grid and clicking the Remove Trigger button.
See also: