Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [INFORMATION] >  [SCHEMA] >  [TRIGGERS]
Private  Storage   

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 22


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 InterSystems IRIS, 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 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=128) [ 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
• 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.


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.