SYSEVENT system table

CREATE TABLE SYS.SYSEVENT (
	event_id		 INT NOT NULL,
	creator	 UNSIGNED INT NOT NULL,
	event_name	 VARCHAR(128) NOT NULL UNIQUE,
	enabled	 CHAR(1) NOT NULL,
	location CHAR(1) NOT NULL,
	event_type_id INT NULL,
	action	 LONG VARCHAR NULL,
	external_action	 LONG VARCHAR NULL,
	condition	 LONG VARCHAR NULL,
	remarks	 LONG VARCHAR NULL,
	source	 LONG VARCHAR NULL,
	PRIMARY KEY ( event_id )
)

Each row in SYSEVENT describes an event created with CREATE EVENT.

event_id The unique number assigned to each event.

creator The user number of the owner of the event. The name of the user can be found by looking in SYSUSERPERM.

event_name The name of the event.

enabled (Y/N) Indicates whether or not the event is allowed to fire.

location The location where the event is allowed to fire:

C = consolidated
R = remote
A = all

event_type_id For system events, the event type as listed in SYSEVENTTYPE.

action The event handler definition.

external_action Not used.

condition The WHERE condition used to control firing of the event handler.

remarks A comment string.

source This column contains the original source for the event handler if the PRESERVE_SOURCE_FORMAT option is ON. It is used to maintain the appearance of the original text. For more information, see “PRESERVE_SOURCE_FORMAT option [database]” in the Sybase IQ System Administration Guide.