Accessing before and after rows

Many trigger actions need to access the values of the rows being changed.

Such trigger actions need to know one or both of the following:

Derby provides transition variables and transition tables for a trigger action to access these values. See "Referencing Old and New Values: The Referencing Clause" in the Derby Reference Manual.

Related concepts
Trigger action overview
Performing referential actions
Triggers and exceptions
Related reference
Examples of trigger actions