Skip to main content

Trigger Syntax and Keywords

This reference describes the syntax and keywords that apply to an SQL trigger, which you can define in persistent classes. Keywords (also known as class attributes) generally affect the compiler.

See Trigger Definitions for links to general information on defining triggers.

See the Table of Contents for a complete list of structures and keywords that apply to specific class members.

  • Syntax of Triggers in Class Definitions – Describes the structure of a trigger definition. See Trigger Definitions for links to general information on defining triggers.
  • 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.
FeedbackOpens in a new tab