Trigger

You manage the triggers of a table from its Structure tab. Triggers are available for MySQL, MariaDB, PostgreSQL, and Redshift.

Changes are kept locally until you press ⌘ + S¹ to commit them to the server.

Create trigger

1. Open the table's Structure tab (⌃ + ⌘ + ]).
2. Click the Triggers button in the bottom bar.
3. In the popover, click + Trigger (⌘ + I), or double-click the empty area below the last trigger.
4. Set the trigger's name, timing (for example BEFORE or AFTER), and event (for example INSERT or UPDATE), then write the trigger statement in the editor below the list.
5. Press ⌘ + S to commit the change.

Edit trigger

1. Open the table's Structure tab (⌃ + ⌘ + ]).
2. Click the Triggers button in the bottom bar to see the table's triggers.
3. Double-click an attribute of the trigger to edit it inline, or select the trigger and edit its statement in the editor.
4. Press ⌘ + S to commit the change.

Delete trigger

1. Open the table's Structure tab (⌃ + ⌘ + ]).
2. Click the Triggers button in the bottom bar to see the table's triggers.
3. Select the trigger and press Delete, or right-click it and choose Delete.
4. Press ⌘ + S to commit the change.