SYSTRIGGER system table

Reference Manual
CHAPTER 15. System Tables

SYSTRIGGER system table

Column name

Column type

Column constraint

Table constraints

trigger_id

SMALLINT

NOT NULL

Primary key

table_id

SMALLINT

NOT NULL

Foreign key references SYS.SYSTABLE. table_id

event

CHAR(1)

NOT NULL

trigger_time

CHAR(1)

NOT NULL

trigger_order

SMALLINT

foreign_table_id

SMALLINT

Foreign key references SYS.SYSFOREIGNKEY

foreign_key_id

SMALLINT

Foreign key references SYS.SYSFOREIGNKEY

referential_action

CHAR(1)

trigger_name

CHAR(128)

trigger_defn

LONG VARCHAR

NOT NULL

remarks

LONG VARCHAR

Column name	Column type	Column constraint	Table constraints
trigger_id	SMALLINT	NOT NULL	Primary key
table_id	SMALLINT	NOT NULL	Foreign key references SYS.SYSTABLE. table_id
event	CHAR(1)	NOT NULL
trigger_time	CHAR(1)	NOT NULL
trigger_order	SMALLINT
foreign_table_id	SMALLINT		Foreign key references SYS.SYSFOREIGNKEY
foreign_key_id	SMALLINT		Foreign key references SYS.SYSFOREIGNKEY
referential_action	CHAR(1)
trigger_name	CHAR(128)
trigger_defn	LONG VARCHAR	NOT NULL
remarks	LONG VARCHAR

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

trigger_id Each trigger is assigned a unique number (the trigger number), which is the primary key for SYSTRIGGER.

table_id The table number uniquely identifies the table to which this trigger belongs.

event 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.

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.