SYSTRIGGER system table
1044
trigger_time 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.
♦
A AFTER
♦
B BEFORE
trigger_order 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 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 The foreign key number of the foreign key for the table
referenced by foreign_table_id.
referential_action 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 The name of the trigger. One table cannot have two triggers
with the same name.
trigger_defn The command that was used to create the trigger.
remarks A comment string.
To Next Page
Loading...