|
|
|
|
|
|
Trigger Time
The trigger time specifies when, in relation to the execution of the triggering data manipulation statement, the trigger is executed.
The possible values for the trigger time are:
- AFTER
This specifies that the trigger will be executed following the execution of the triggering data manipulation statement.
- BEFORE
This specifies that the trigger will be executed prior to the execution of the triggering data manipulation statement.
- INSTEAD OF
This specifies that the trigger will execute when the triggering data manipulation statement would normally be executed. In this case the triggering data manipulation statement itself has no direct effect, it only causes the trigger to execute.
If the trigger time specified is AFTER or BEFORE, the table name must specify a base table which is located in a databank with the TRANS or LOG option.
If the trigger time specified is INSTEAD OF, the table name must specify a view.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|