|The jOOQ User Manual : SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TRIGGER||previous : next|
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
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.