Support for triggers differs as follows:
Adaptive Server Anywhere supports both row-level and statement-level triggers.
Adaptive Server Enterprise supports only statement-level triggers.
IQ does not support triggers.
A trigger is effectively a stored procedure that is
run automatically either immediately before or immediately after
an INSERT, UPDATE, or DELETE as part of the same transaction, that
can be used to cause a dependent change (for example, to automatically
update the name of an employee’s manager when the employee
is moved to a different department). It can also be used to write
an audit trail to identify which modifications made which changes
to the database, and at what time.
