Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » Views » System views


SYSEVENT system view

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 or not the event is allowed to fire.
location CHAR(1) The location where the event is to fire:
  • C = consolidated
  • R = remote
  • A = all
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.
Constraints on underlying system table

PRIMARY KEY (event_id)

FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL

See also