Triggers

---

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 ATOMIC.

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 info@mimer.se