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.
|
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) |
|
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.
|
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. |
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)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |