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 | Data type | Description |
---|---|---|
trigger_id | UNSIGNED INT | A unique number for the trigger in the SYSTRIGGER view. |
table_id | UNSIGNED INT | The table ID of the table to which this trigger belongs. |
object_id | UNSIGNED BIGINT | The object ID for the trigger in the database. |
event | CHAR(1) |
The operation that will cause the trigger to fire.
|
trigger_time | CHAR(1) |
The time when the trigger will fire relative to the event.
|
trigger_order | SMALLINT |
The order in which are fired when there are multiple triggers of the same type (insert, update, or delete) set to fire at the same time (applies to BEFORE or AFTER triggers only, only). |
foreign_table_id | UNSIGNED INT | The ID of the table containing a foreign key definition that has a referential triggered action (such as ON DELETE CASCADE). The foreign_table_id value reflects the value of ISYSIDX.table_id. |
foreign_key_id | UNSIGNED INT | The ID of the foreign key for the table referenced by foreign_table_id. The foreign_key_id value reflects the value of ISYSIDX.index_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. |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |