Online Documentation for SQL Manager for MySQL

Triggers

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database.

Data manipulation language triggers are executed in response to user's attempts to change data with the help of DML. DML events include INSERT, UPDATE and DELETE operations which can be applied to a table.

Table triggers are managed within the Triggers tab of Table Editor.

Trigger Editor allows you to specify trigger definition and set trigger properties. It opens automatically when you create a new trigger and is available on editing an existing one.

To open a trigger in Trigger Editor, double-click it in the DB Explorer tree, or use the Edit Trigger... item of the context menu within the Triggers tab of Table Editor.

• Using Navigation bar and Toolbar
• Editing trigger definition
• Viewing DDL definition