Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous section

UpdateColumnList

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