A trigger is a specification that the database should automatically execute a particular function whenever a certain type of operation is performed. Triggers can be defined to execute either before or after any INSERT, UPDATE, or DELETE operation, either once per modified row, or once per SQL statement.

Triggers are managed on the Triggers tab of the Table Designer. Just simply click a trigger field for editing. A right-click displays the popup menu or using the toolbar below, allowing you to create new, edit and delete the selected trigger field.

Note: To create a trigger on a table, the user must have the TRIGGER privilege on the table.

Add Trigger

To add a trigger

• Open the table in the Table Designer.
• Open the Triggers tab.
• Right-click and select the Add Trigger from the popup menu or click the Add Trigger from the toolbar.
• Edit trigger properties.

Edit Trigger

To edit a trigger

• Open the table in the Table Designer.
• Open the Triggers tab.
• Just simply click on the trigger to edit.

Delete Trigger

To delete a trigger

• Open the table in the Table Designer.
• Open the Triggers tab.
• Right-click on the trigger to delete and select the Delete Trigger from the popup menu or click the Delete Trigger from the toolbar.
• Confirm deleting in the dialog window.

See also:
Setting Trigger Name and Statement
Setting Trigger Time and Event