|
|
Triggers
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
AFTER,BEFOREorINSTEAD 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 Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se |
|
|