|The jOOQ User Manual : SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER||previous : next|
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
DEFAULTin a table definition doesn't do the trick)
- Performing additional integrity checks prior to any DML statement (e.g. when a
CHECKconstraint doesn't suffice)
- Logging extra data, such as audit data.