Support for triggers differs between
Adaptive Server, SQL Anywhere, and
SAP Sybase IQ.
SQL Anywhere supports both row-level and statement-level
triggers.
Adaptive Server supports only statement-level
triggers.
SAP Sybase IQ does not support triggers.
Note: 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.