Trigger Syntax and Keywords

This reference describes the syntax and keywords that apply to an SQL trigger, which you can define in persistent classes.

• Syntax of Triggers in Class Definitions – Describes the structure of a trigger definition.
• 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 for this trigger.
• OldTable – Specifies the name of the transition table that stores the old values of the row or statement affected by the event for this trigger.
• 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.