Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15

CREATE TRIGGER

Applies to ❌ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

Most dialects support triggers, which is SQL or procedural logic that executes at certain events to perform actions including:

  • Changing the data about to be inserted or updated (e.g. when a column DEFAULT in a table definition doesn't do the trick)
  • Performing additional integrity checks prior to any DML statement (e.g. when a CHECK constraint doesn't suffice)
  • Logging extra data, such as audit data.
  • Etc.

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo