Skip to main content

INFORMATION.SCHEMA.TRIGGERS

Class INFORMATION.SCHEMA.TRIGGERS Extends %Library.Persistent [ ClassType = persistent, Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = TRIGGERS, StorageStrategy = SQLStorage, System = 4 ]

Returns one row for each trigger for tables that can be accessed by the current user in the current namespace.

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

SchemaExact​

Property SchemaExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 20 ];

TableExact​

Property TableExact As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 21 ];

TriggerObjName​

Property TriggerObjName As %String(MAXLEN = 128) [ Internal, Private, Required, SqlColumnNumber = 22 ];

SystemTable​

Property SystemTable As %Integer [ Calculated, Internal, Private, Required, SqlColumnNumber = 23, SqlComputeCode = { set {*}=$s($e({TABLE_SCHEMA})="%"||({TABLE_SCHEMA}="INFORMATION_SCHEMA"):1,1:0) }, SqlComputed ];

Is the table a system table (1 or 0)

TABLECATALOG​

Property TABLECATALOG As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 2, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = TABLE_CATALOG ];

Table qualifier - always NULL in InterSystems IRIS

TABLESCHEMA​

Property TABLESCHEMA As %String(COLLATION = "Upper", MAXLEN = 128) [ Calculated, Required, SqlColumnNumber = 3, SqlComputeCode = { set {*}={SchemaExact} }, SqlComputed, SqlFieldName = TABLE_SCHEMA ];

Name of schema that contains the table.

TABLENAME​

Property TABLENAME As %String(COLLATION = "Upper", MAXLEN = 128) [ Calculated, Required, SqlColumnNumber = 4, SqlComputeCode = { set {*}={TableExact} }, SqlComputed, SqlFieldName = TABLE_NAME ];

Name of the table.

TRIGGERNAME​

Property TRIGGERNAME As %String(COLLATION = "Upper", MAXLEN = 128) [ Required, SqlColumnNumber = 5, SqlFieldName = TRIGGER_NAME ];

Name of the trigger.

EVENTMANIPULATION​

Property EVENTMANIPULATION As %String(MAXLEN = 48) [ SqlColumnNumber = 6, SqlFieldName = EVENT_MANIPULATION ];

Event for this trigger, typically INSERT, UPDATE, or DELETE

EVENTOBJECTCATALOG​

Property EVENTOBJECTCATALOG As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 7, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = EVENT_OBJECT_CATALOG ];

EVENT_OBJECT_CATALOG is not currently used by InterSystems IRIS, reserved for future use.

EVENTOBJECTSCHEMA​

Property EVENTOBJECTSCHEMA As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 8, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = EVENT_OBJECT_SCHEMA ];

EVENT_OBJECT_SCHEMA is not currently used by InterSystems IRIS, reserved for future use.

EVENTOBJECTTABLE​

Property EVENTOBJECTTABLE As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 9, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = EVENT_OBJECT_TABLE ];

EVENT_OBJECT_TABLE is not currently used by InterSystems IRIS, reserved for future use.

ACTIONORDER​

Property ACTIONORDER As %Integer [ SqlColumnNumber = 10, SqlFieldName = ACTION_ORDER ];

Column's ordinal position within the table.

ACTIONCONDITION​

Property ACTIONCONDITION As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 11, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = ACTION_CONDITION ];

ACTION_CONDITION is not currently used by InterSystems IRIS, reserved for future use.

ACTIONSTATEMENT​

Property ACTIONSTATEMENT As %String(MAXLEN = "") [ SqlColumnNumber = 12, SqlFieldName = ACTION_STATEMENT ];

ACTION_STATEMENT is not currently used by InterSystems IRIS, reserved for future use.

ACTIONORIENTATION​

Property ACTIONORIENTATION As %String(MAXLEN = 10, VALUELIST = ",ROW,ROW/OBJECT,STATEMENT") [ SqlColumnNumber = 13, SqlFieldName = ACTION_ORIENTATION ];

Foreach specification, ROW, ROW/OBJECT, or STATEMENT

ACTIONTIMING​

Property ACTIONTIMING As %String(MAXLEN = 6, VALUELIST = ",BEFORE,AFTER") [ SqlColumnNumber = 14, SqlFieldName = ACTION_TIMING ];

Time, BEFORE or AFTER
BEFORE - the trigger's Time is BEFORE
AFTER - the trigger's Time is AFTER

ACTIONREFERENCEOLDTABLE​

Property ACTIONREFERENCEOLDTABLE As %String(MAXLEN = 128) [ SqlColumnNumber = 15, SqlFieldName = ACTION_REFERENCE_OLD_TABLE ];

Trigger's old table name

ACTIONREFERENCENEWTABLE​

Property ACTIONREFERENCENEWTABLE As %String(MAXLEN = 128) [ SqlColumnNumber = 16, SqlFieldName = ACTION_REFERENCE_NEW_TABLE ];

Trigger's new table name

ACTIONREFERENCEOLDROW​

Property ACTIONREFERENCEOLDROW As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 17, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = ACTION_REFERENCE_OLD_ROW ];

ACTION_REFERENCE_OLD_ROW is not currently used by InterSystems IRIS, reserved for future use.

ACTIONREFERENCENEWROW​

Property ACTIONREFERENCENEWROW As %String(MAXLEN = 128) [ Calculated, SqlColumnNumber = 18, SqlComputeCode = { set {*}=""}, SqlComputed, SqlFieldName = ACTION_REFERENCE_NEW_ROW ];

ACTION_REFERENCE_NEW_ROW is not currently used by InterSystems IRIS, reserved for future use.

CREATED​

Property CREATED As %TimeStamp [ SqlColumnNumber = 19, SqlFieldName = CREATED ];

Time trigger was created This is actually the time the class that defines the table was last changed as the IRIS class metadata cannot account for when the trigger was actually created