A transition table is a dynamically created table that you can reference using a correlation name.
The following table indicates the type of rows that are contained by a transition table depending on the triggering statement that caused the transition table to be created.
|Triggering Statement||Generates a Transition Table with this Row Set|
|DELETE||Old rows only.|
|INSERT||New rows only.|
||Old and new rows.|
The following table documents the rows that can be referenced in a transition table depending on trigger granularity.
|Trigger Granularity||References Rows for this Transition Table|