16.20 - OLD - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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.