A trigger is a named database object that is associated with a table and that is activated when a particular event occurs for the table.

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: Trigger support from MySQL 5.0.2 or later.

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, Time and Statement
Setting Trigger Event