solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables : SYS_TRIGGERS
  
SYS_TRIGGERS
The SYS_TRIGGERS system table lists triggers.
Specific users are restricted from viewing triggers. Owners are restricted to viewing only those triggers that they have created. Normal users are restricted from viewing triggers. No restrictions apply to DBAs.
The columns in the SYS_TRIGGERS system table are described in the following table:
 
Column name
Data type
Description
ID
INTEGER
Unique table identifier.
TRIGGER_NAME
WVARCHAR
Trigger name.
TRIGGER_TEXT
LONG WVARCHAR
Trigger body.
TRIGGER_BIN
LONG VARBINARY
Compiled form of the trigger.
TRIGGER_SCHEMA
WVARCHAR
The name of the schema containing TRIGGER_NAME.
TRIGGER_CATALOG
WVARCHAR
The name of the catalog containing TRIGGER_NAME.
TRIGGER_ENABLED
CHAR
If triggers are enabled "YES"; otherwise "NO".
CREATIME
TIMESTAMP
The creation time of the trigger.
TYPE
INTEGER
Reserved for future use.
REL_ID
INTEGER
The relation identifier.
Go up to
System tables