This chapter discusses triggers: how to create them, execute them and drop them.
A trigger defines an SQL statement that is to be executed before, after or instead of a specified data manipulation operation on a named table or view.
The execution of the SQL statement can be made conditional on the evaluation of a search condition.
The SQL statement is typically a compound SQL statement, thus allowing a number of SQL statements to be executed by the trigger. The compound SQL statement must be defined as
Thus, the body of a trigger is similar to the body of a routine and the same constructs may be used within it.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40