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.

Table of contents

3.6.3.10.1.

Events

3.6.3.10.2.

REFERENCING clause

3.6.3.10.3.

STATEMENT vs ROW triggers

3.6.3.10.4.

WHEN clause