Each row in the SYSEVENT system view describes an event created with CREATE EVENT. The underlying system table for this view is ISYSEVENT.
Column name | Column type | Description |
---|---|---|
event_id | UNSIGNED INT | The unique number assigned to each event. |
object_id | UNSIGNED BIGINT | The internal ID for the event, uniquely identifying it in the database. |
creator | UNSIGNED INT | The user number of the owner of the event. The name of the user can be found by looking in the SYSUSER system view. |
event_name | VARCHAR(128) | The name of the event. |
enabled | CHAR(1) | Indicates whether the event is allowed to fire. |
location | CHAR(1) | The location where the event is to fire:
|
event_type_id | UNSIGNED INT | For system events, the event type as listed in the SYSEVENTTYPE system view. |
action | LONG VARCHAR | The event handler definition. An obfuscated value indicates a hidden event. |
external_action | LONG VARCHAR | For system use only. |
condition | LONG VARCHAR | The condition used to control firing of the event handler. |
remarks | LONG VARCHAR | Remarks for the event; this column comes from ISYSREMARK. |
source | LONG VARCHAR | The original source for the event; this column comes from ISYSSOURCE. |
PRIMARY KEY (event_id)
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |