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

Teradata Vantageā„¢ - Advanced SQL Engine Release Definition

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Release Notes
Publication ID
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.