17.10 - CREATE/REPLACE TRIGGER WHEN Clause - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Release Definition

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1725-171K
Language
English (United States)

The CREATE TRIGGER and REPLACE TRIGGER statements have an optional WHEN clause that specifies a search condition. As of Release 17.10, you must qualify column names in the search condition with OLD or NEW unless they are in a subquery.