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:
The name of the trigger. It must be different from any other trigger name of the same table.
Select stored procedure from the list of the defined ones within the diagram. This function will be executed when the trigger fires.
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.
Determines whether the function is called before or after the event.
A boolean expression that determines whether the trigger function will actually be executed. If WHEN is specified, the function will only be called if the condition returns true. In FOR EACH ROW triggers, the WHEN condition can refer to columns of the old and/or new row values by writing OLD.column_name or NEW.column_name respectively. Of course, INSERT triggers cannot refer to OLD and DELETE triggers cannot refer to NEW.
Indicates the kind of statement that activates the trigger. It can be INSERT, UPDATE, DELETE or TRUNCATE.
Defines comment for trigger object.
The buttons under the list of triggers allow you to perform the following actions: