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.4.3.9.1.

Events (new)

3.4.3.9.2.

REFERENCING clause (new)

3.4.3.9.3.

STATEMENT vs ROW triggers (new)

3.4.3.9.4.

WHEN clause (new)