UpdateColumnList (Trigger Keyword)
Specifies one or more columns whose modification causes the trigger to be fired by SQL. Available only for TSQL.
Usage
To specify the columns whose modification fires the trigger, use the following syntax:
Trigger name [ Event = sqlevent, UpdateColumnList = updatecolumnlist ] { //implementation }
Where updatecolumnlist is either a column name or comma-separated list of column names, enclosed in parentheses.
Details
This keyword specifies one or more columns whose modification causes the trigger to be fired. Note that this keyword is only available for TSQL.
See Also
-
“Trigger Definitions” in this book
-
“Defining Method and Trigger Generators” in Defining and Using Classes
-
“Using Triggers” in Using InterSystems SQL
-
“Introduction to Compiler Keywords” in Defining and Using Classes
