SYSTRIGGER system view

Each row in the SYSTRIGGER system view describes one trigger in the database. This view also contains triggers that are automatically created for foreign key definitions which have a referential triggered action (such as ON DELETE CASCADE). The underlying system table for this view is ISYSTRIGGER.

Column name Column type Description
trigger_id UNSIGNED INT Each trigger is assigned a unique number (the trigger number).
table_id UNSIGNED INT The table ID of the table to which this trigger belongs.
object_id UNSIGNED BIGINT The event or events that cause the trigger to fire. This single-character value corresponds to the trigger event that was specified when the trigger was created.
  • A - INSERT, DELETE
  • B - INSERT, UPDATE
  • C - UPDATE COLUMNS
  • D - DELETE
  • E - DELETE, UPDATE
  • I - INSERT
  • U - UPDATE
  • M - INSERT, DELETE, UPDATE
event CHAR(1) The time at which the trigger will fire. This single-character value corresponds to the trigger time that was specified when the trigger was created.
trigger_time CHAR(1)
  • A - AFTER (row-level trigger)
  • B - BEFORE (row-level trigger)
  • I - INSTEAD OF (row-level trigger)
  • K - INSTEAD OF (statement-level trigger)
  • R - RESOLVE
  • S - AFTER (statement-level trigger)
trigger_order SMALLINT The order in which the trigger will fire. This determines the order that triggers are fired when there are triggers of the same type (insert, update, or delete) that fire at the same time (before or after).
foreign_table_id UNSIGNED INT The table number of the table containing a foreign key definition which has a referential triggered action (such as ON DELETE CASCADE).
foreign_key_id UNSIGNED INT The foreign key number of the foreign key for the table referenced by foreign_table_id.
referential_action CHAR(1) The action defined by a foreign key. This single-character value corresponds to the action that was specified when the foreign key was created.
  • C - CASCADE
  • D - SET DEFAULT
  • N - SET NULL
  • R - RESTRICT
trigger_name CHAR(128) The name of the trigger. One table cannot have two triggers with the same name.
trigger_defn LONG VARCHAR The command that was used to create the trigger.
remarks LONG VARCHAR Remarks about the trigger. This value is stored in the ISYSREMARK system table.
source LONG VARCHAR The SQL source for the trigger. This value is stored in the ISYSSOURCE system table.
Constraints on underlying system table

PRIMARY KEY (trigger_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL

FOREIGN KEY (table_id) references SYS.ISYSTAB (table_id)

FOREIGN KEY fkey_index (foreign_table_id, foreign_key_id) references SYS.ISYSIDX (table_id, index_id)