A trigger defines a number of procedural SQL statements that are executed whenever a specified data manipulation statement is executed on the table or view on which the trigger has been created.
There are two types of triggers, row triggers and statement triggers. A row trigger is executed once for each row that is modified by a data manipulation operation. A statement trigger is invoked once for a data manipulation operation.
The trigger can be set up to execute
INSTEAD OFthe data manipulation statement. Trigger execution can also be made conditional on a search condition specified as part of the trigger.
Read more in the Mimer SQL Programmer's Manual, Triggers.
Mimer Information Technology AB
Phone: +46 18 780 92 00