RDBMS Fundamentals

Trigger

English

Overview

Logic that automatically runs in response to a specific operation.

Details

Logic that automatically runs when tied to an event such as INSERT, UPDATE, or DELETE, used for tasks like recording an audit log or maintaining consistency. There are BEFORE triggers, which run before the operation, and AFTER triggers, which run after -- and an unintended chain where one trigger fires another can make debugging genuinely difficult.

More Database terms