When you expand an ASA database profile in the Objects view, an Events folder displays at the top level. Expanding the folder displays any event handlers defined for the database. Expanding a table in an ASA or Adaptive Server profile in the Objects view displays a Triggers folder.

A trigger is a special form of stored procedure that is associated with a specific database table. Triggers fire automatically whenever someone inserts, updates or deletes rows of the associated table. Triggers can call procedures and fire other triggers, but they have no parameters and cannot be invoked by a CALL statement. You use triggers when referential integrity and other declarative constraints are insufficient.

Events can be used in an ASA database to automate database administration tasks, such as sending a message when disk space is low. Event handlers are activated when a provided trigger condition is met. If any events are defined for an ASA connection, they display in the Events folder for the connection in the Objects view.

Click Properties on an event or trigger's pop-up menu to display information about it in the Object Details view. You can also drag its icon to the Object Details view to display its properties or to the ISQL view to paste its definition.