Home > Class Reference > %SYS namespace > INFORMATION.SCHEMA.TRIGGERS
Private   Storage    

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.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 18

Summary

Properties
ACTIONCONDITION ACTIONORDER ACTIONORIENTATION ACTIONREFERENCENEWROW
ACTIONREFERENCENEWTABLE ACTIONREFERENCEOLDROW ACTIONREFERENCEOLDTABLE ACTIONSTATEMENT
ACTIONTIMING CREATED EVENTMANIPULATION EVENTOBJECTCATALOG
EVENTOBJECTSCHEMA EVENTOBJECTTABLE TABLECATALOG TABLENAME
TABLESCHEMA TRIGGERNAME
Methods
%AddToSaveSet %AddToSyncSet %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 %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SerializeObject
%SetModified %SortBegin %SortEnd %SyncObjectIn
%SyncTransport %UnlockExtent %UnlockId %ValidateIndices
%ValidateObject

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 Caché, reserved for future use.
property ACTIONORDER as %Integer [ SqlFieldName = ACTION_ORDER,Required ];
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 Caché, 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 Caché, 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=128) [ SqlFieldName = ACTION_STATEMENT ];
ACTION_STATEMENT is not currently used by Caché, 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
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 Caché, reserved for future use.
property EVENTOBJECTSCHEMA as %String(MAXLEN=128) [ Calculated,SqlFieldName = EVENT_OBJECT_SCHEMA ];
EVENT_OBJECT_SCHEMA is not currently used by Caché, reserved for future use.
property EVENTOBJECTTABLE as %String(MAXLEN=128) [ Calculated,SqlFieldName = EVENT_OBJECT_TABLE ];
EVENT_OBJECT_TABLE is not currently used by Caché, reserved for future use.
property TABLECATALOG as %String(MAXLEN=128) [ Calculated,SqlFieldName = TABLE_CATALOG ];
Table qualifier - always NULL in Caché
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.