Skip to content

Editing table triggers

A trigger is a small piece of SQL that runs automatically whenever rows are inserted, updated, or deleted — useful for keeping an audit log, maintaining a derived value, or enforcing a rule that goes beyond a simple constraint. Triggers are managed on the Triggers sub-tab of the Design tab.

The Triggers sub-tab The Triggers sub-tab

To add a trigger:

  1. Click Add to open the trigger designer.

    The trigger designer The trigger designer

  2. Build the CREATE TRIGGER statement visually — choose when it fires (before or after INSERT, UPDATE, or DELETE), an optional condition, and the SQL it runs.

  3. Click OK.

To modify a trigger: select it, click Modify, adjust it, and click OK.

To delete a trigger: select it, click Delete, and confirm.

Tip

The designer writes standard SQL, so you can always review the generated CREATE TRIGGER statement — a good way to learn the syntax while you build.

See also: Editing a table · Applying the changes after editing a table