A trigger defines events that happen when another event, called a triggering event, occurs. A trigger is a stored SQL statement associated with a table called a subject table.
Vantage implementation of triggers complies with ANSI SQL specifications and provides extensions.
Triggers execute when any of the following modifies a specified column or columns in the subject table:
- DELETE
- INSERT
- UPDATE
Typically, the stored SQL statements perform a DELETE, INSERT, UPDATE, or MERGE on a table different from the subject table.