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 |
|---|---|
| Row |
|
| Statement |
|