15.10 - OLD - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
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.