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" under the "CREATE TRIGGER statement" topic in the Derby Reference Manual.

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