Class INFORMATION.SCHEMA.TRIGGERS

persistent class INFORMATION.SCHEMA.TRIGGERS extends %Library.Persistent

SQL Table Name: TRIGGERS

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

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	22

Summary

Properties
ACTIONCONDITION	ACTIONORDER	ACTIONORIENTATION	ACTIONREFERENCENEWROW
ACTIONREFERENCENEWTABLE	ACTIONREFERENCEOLDROW	ACTIONREFERENCEOLDTABLE	ACTIONSTATEMENT
ACTIONTIMING	CREATED	EVENTMANIPULATION	EVENTOBJECTCATALOG
EVENTOBJECTSCHEMA	EVENTOBJECTTABLE	TABLECATALOG	TABLENAME
TABLESCHEMA	TRIGGERNAME

Methods
%AddToSaveSet	%AddToSyncSet	%BuildDeferredIndices	%BuildIndicesAsync
%BuildIndicesAsyncResponse	%CheckConstraints	%CheckConstraintsForExtent	%ClassIsLatestVersion
%ClassName	%ComposeOid	%ConstructClone	%Delete
%DeleteExtent	%DeleteId	%DispatchClassMethod	%DispatchGetModified
%DispatchGetProperty	%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty
%DispatchSetProperty	%Exists	%ExistsId	%Extends
%GUID	%GUIDSet	%GetLock	%GetParameter
%GetSwizzleObject	%Id	%IsA	%IsModified
%IsNull	%KillExtent	%LockExtent	%LockId
%New	%NormalizeObject	%ObjectIsNull	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDeleteFinally	%OnDetermineClass
%OnOpenFinally	%OnSaveFinally	%Open	%OpenId
%OriginalNamespace	%PackageName	%PurgeIndices	%Reload
%RemoveFromSaveSet	%ResolveConcurrencyConflict	%RollBack	%Save
%SaveDirect	%SerializeObject	%SetModified	%SortBegin
%SortEnd	%SyncObjectIn	%SyncTransport	%UnlockExtent
%UnlockId	%ValidateIndices	%ValidateObject	%ValidateTable

Parameters

• parameter READONLY = 1;

READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

• property ACTIONCONDITION as %String(MAXLEN=128) [ Calculated,SqlFieldName = ACTION_CONDITION ];

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

• property ACTIONORDER as %Integer [ SqlFieldName = ACTION_ORDER ];

Column's ordinal position within the table.

• property ACTIONORIENTATION as %String(MAXLEN=10,VALUELIST=",ROW,ROW/OBJECT,STATEMENT") [ SqlFieldName = ACTION_ORIENTATION ];

Foreach specification, ROW, ROW/OBJECT, or STATEMENT

• property ACTIONREFERENCENEWROW as %String(MAXLEN=128) [ Calculated,SqlFieldName = ACTION_REFERENCE_NEW_ROW ];

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

• property ACTIONREFERENCENEWTABLE as %String(MAXLEN=128) [ SqlFieldName = ACTION_REFERENCE_NEW_TABLE ];

Trigger's new table name

• property ACTIONREFERENCEOLDROW as %String(MAXLEN=128) [ Calculated,SqlFieldName = ACTION_REFERENCE_OLD_ROW ];

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

• property ACTIONREFERENCEOLDTABLE as %String(MAXLEN=128) [ SqlFieldName = ACTION_REFERENCE_OLD_TABLE ];

Trigger's old table name

• property ACTIONSTATEMENT as %String(MAXLEN="") [ SqlFieldName = ACTION_STATEMENT ];

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

• property ACTIONTIMING as %String(MAXLEN=6,VALUELIST=",BEFORE,AFTER") [ SqlFieldName = ACTION_TIMING ];

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

• property CREATED as %TimeStamp [ 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

• property EVENTMANIPULATION as %String(MAXLEN=48) [ SqlFieldName = EVENT_MANIPULATION ];

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

• property EVENTOBJECTCATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = EVENT_OBJECT_CATALOG ];

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

• property EVENTOBJECTSCHEMA as %String(MAXLEN=128) [ Calculated,SqlFieldName = EVENT_OBJECT_SCHEMA ];

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

• property EVENTOBJECTTABLE as %String(MAXLEN=128) [ Calculated,SqlFieldName = EVENT_OBJECT_TABLE ];

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

• property TABLECATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = TABLE_CATALOG ];

Table qualifier - always NULL in InterSystems IRIS

• property TABLENAME as %String(COLLATION="Upper",MAXLEN=128) [ Calculated,SqlFieldName = TABLE_NAME,Required ];

Name of the table.

• property TABLESCHEMA as %String(COLLATION="Upper",MAXLEN=128) [ Calculated,SqlFieldName = TABLE_SCHEMA,Required ];

Name of schema that contains the table.

• property TRIGGERNAME as %String(COLLATION="Upper",MAXLEN=128) [ SqlFieldName = TRIGGER_NAME,Required ];

Name of the trigger.

Class Reference IRIS for UNIX 2024.1.2
Documentation Search