16.20 - OLD - Teradata Database - Teradata Vantage NewSQL Engine

OLD ROW

Introduction to a correlation name for the current row before it is modified. The current row is called a transition row. The ROW keyword is optional.

You can specify OLD or OLD ROW only for ROW triggers.

You can specify a normalize Period column for OLD or OLD ROW.

OLD and OLD ROW are valid only for DELETE, MERGE UPDATE, and UPDATE triggering events.

AS old_transition_variable_name

Row alias name specified with the OLD or OLD ROW option used for referencing old values in the current row of the transition table.

The AS keyword preceding old_transition_variable_name is optional.