Previous section   Next section

Trigger Keywords

This reference describes the keywords that apply to an SQL trigger, which you can define in persistent classes. These keywords (also known as class attributes) generally affect the compiler.
For general information on trigger definitions, see “Trigger Definitions.”
  • CodeMode – Specifies how this trigger is implemented.
  • Event – Specifies the SQL events that will fire this trigger. Required (no default).
  • Final – Specifies whether this trigger is final (cannot be overridden in subclasses).
  • Foreach – Controls when the trigger is fired.
  • Internal – Specifies whether this trigger definition is internal (not displayed in the class documentation).
  • Language – Specifies the language in which the trigger is written.
  • NewTable – Specifies the name of the transition table that stores the new values of the row or statement affected by the event.
  • OldTable – Specifies the name of the transition table that stores the old values of the row or statement affected by the event.
  • Order – In the case of multiple triggers for the same EVENT and TIME, specifies the order in which the triggers should be fired.
  • SqlName – Specifies the SQL name to use for this trigger.
  • Time – Specifies whether the trigger is fired before or after the event.
  • UpdateColumnList – Specifies one or more columns whose modification causes the trigger to be fired by SQL. Available only for TSQL.
Previous section   Next section