Trigger Editor

Trigger Editor is placed within the Table Editor dialog. It allows you to modify table triggers.

The main element of the editor is the trigger list, which displays all the triggers in the table and their properties. These properties are as follows:

Trigger Name

The name of the trigger. It must be different from any other trigger name of the same table.

Trigger Time

Determines whether the function is called before or after the event.

Trigger Event

Indicates the kind of statement that activates the trigger. It can be INSERT, UPDATE, or DELETE.

Target

It specifies whether the trigger procedure will be fired once for every row affected by the trigger event, or just once per SQL statement. If neither is specified, then the trigger procedure FOR EACH STATEMENT is the default.

Procedure

Select stored procedure from the list of the defined ones within the diagram. This function will be executed when the trigger fires.

Generate

Enables trigger creation during Database Generation and Database Modification.

The buttons under the list of triggers allow you to perform the following actions:

• Add - add a new trigger to the end of the list;
• Delete - remove the selected trigger from the list;
• Up/Down - move the selected trigger along the list.