Skip to main content

INFORMATION.SCHEMA.TRIGGERS

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

SQL Table Name: INFORMATION_SCHEMA.TRIGGERS

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

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: 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 methods: ACTIONCONDITIONCompute(), ACTIONCONDITIONDisplayToLogical(), ACTIONCONDITIONGet(), ACTIONCONDITIONIsValid(), ACTIONCONDITIONLogicalToDisplay(), ACTIONCONDITIONLogicalToOdbc(), ACTIONCONDITIONNormalize(), ACTIONCONDITIONSQLCompute()
property ACTIONORDER as %Integer [ SqlFieldName = ACTION_ORDER ];
Column's ordinal position within the table.
Property methods: ACTIONORDERDisplayToLogical(), ACTIONORDERGet(), ACTIONORDERIsValid(), ACTIONORDERLogicalToDisplay(), ACTIONORDERNormalize(), ACTIONORDERSet()
property ACTIONORIENTATION as %String (MAXLEN = 10, VALUELIST = ",ROW,ROW/OBJECT,STATEMENT") [ SqlFieldName = ACTION_ORIENTATION ];
Foreach specification, ROW, ROW/OBJECT, or STATEMENT
Property methods: ACTIONORIENTATIONDisplayToLogical(), ACTIONORIENTATIONGet(), ACTIONORIENTATIONIsValid(), ACTIONORIENTATIONLogicalToDisplay(), ACTIONORIENTATIONLogicalToOdbc(), ACTIONORIENTATIONNormalize(), ACTIONORIENTATIONSet()
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 methods: ACTIONREFERENCENEWROWCompute(), ACTIONREFERENCENEWROWDisplayToLogical(), ACTIONREFERENCENEWROWGet(), ACTIONREFERENCENEWROWIsValid(), ACTIONREFERENCENEWROWLogicalToDisplay(), ACTIONREFERENCENEWROWLogicalToOdbc(), ACTIONREFERENCENEWROWNormalize(), ACTIONREFERENCENEWROWSQLCompute()
property ACTIONREFERENCENEWTABLE as %String (MAXLEN = 128) [ SqlFieldName = ACTION_REFERENCE_NEW_TABLE ];
Trigger's new table name
Property methods: ACTIONREFERENCENEWTABLEDisplayToLogical(), ACTIONREFERENCENEWTABLEGet(), ACTIONREFERENCENEWTABLEIsValid(), ACTIONREFERENCENEWTABLELogicalToDisplay(), ACTIONREFERENCENEWTABLELogicalToOdbc(), ACTIONREFERENCENEWTABLENormalize(), ACTIONREFERENCENEWTABLESet()
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 methods: ACTIONREFERENCEOLDROWCompute(), ACTIONREFERENCEOLDROWDisplayToLogical(), ACTIONREFERENCEOLDROWGet(), ACTIONREFERENCEOLDROWIsValid(), ACTIONREFERENCEOLDROWLogicalToDisplay(), ACTIONREFERENCEOLDROWLogicalToOdbc(), ACTIONREFERENCEOLDROWNormalize(), ACTIONREFERENCEOLDROWSQLCompute()
property ACTIONREFERENCEOLDTABLE as %String (MAXLEN = 128) [ SqlFieldName = ACTION_REFERENCE_OLD_TABLE ];
Trigger's old table name
Property methods: ACTIONREFERENCEOLDTABLEDisplayToLogical(), ACTIONREFERENCEOLDTABLEGet(), ACTIONREFERENCEOLDTABLEIsValid(), ACTIONREFERENCEOLDTABLELogicalToDisplay(), ACTIONREFERENCEOLDTABLELogicalToOdbc(), ACTIONREFERENCEOLDTABLENormalize(), ACTIONREFERENCEOLDTABLESet()
property ACTIONSTATEMENT as %String) [ SqlFieldName = ACTION_STATEMENT ];
ACTION_STATEMENT is not currently used by InterSystems IRIS, reserved for future use.
Property methods: ACTIONSTATEMENTDisplayToLogical(), ACTIONSTATEMENTGet(), ACTIONSTATEMENTIsValid(), ACTIONSTATEMENTLogicalToDisplay(), ACTIONSTATEMENTLogicalToOdbc(), ACTIONSTATEMENTNormalize(), ACTIONSTATEMENTSet()
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 methods: ACTIONTIMINGDisplayToLogical(), ACTIONTIMINGGet(), ACTIONTIMINGIsValid(), ACTIONTIMINGLogicalToDisplay(), ACTIONTIMINGLogicalToOdbc(), ACTIONTIMINGNormalize(), ACTIONTIMINGSet()
property CREATED as %TimeStamp;
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 methods: CREATEDDisplayToLogical(), CREATEDGet(), CREATEDIsValid(), CREATEDLogicalToDisplay(), CREATEDNormalize(), CREATEDOdbcToLogical(), CREATEDSet()
property EVENTMANIPULATION as %String (MAXLEN = 48) [ SqlFieldName = EVENT_MANIPULATION ];
Event for this trigger, typically INSERT, UPDATE, or DELETE
Property methods: EVENTMANIPULATIONDisplayToLogical(), EVENTMANIPULATIONGet(), EVENTMANIPULATIONIsValid(), EVENTMANIPULATIONLogicalToDisplay(), EVENTMANIPULATIONLogicalToOdbc(), EVENTMANIPULATIONNormalize(), EVENTMANIPULATIONSet()
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 methods: EVENTOBJECTCATALOGCompute(), EVENTOBJECTCATALOGDisplayToLogical(), EVENTOBJECTCATALOGGet(), EVENTOBJECTCATALOGIsValid(), EVENTOBJECTCATALOGLogicalToDisplay(), EVENTOBJECTCATALOGLogicalToOdbc(), EVENTOBJECTCATALOGNormalize(), EVENTOBJECTCATALOGSQLCompute()
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 methods: EVENTOBJECTSCHEMACompute(), EVENTOBJECTSCHEMADisplayToLogical(), EVENTOBJECTSCHEMAGet(), EVENTOBJECTSCHEMAIsValid(), EVENTOBJECTSCHEMALogicalToDisplay(), EVENTOBJECTSCHEMALogicalToOdbc(), EVENTOBJECTSCHEMANormalize(), EVENTOBJECTSCHEMASQLCompute()
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 methods: EVENTOBJECTTABLECompute(), EVENTOBJECTTABLEDisplayToLogical(), EVENTOBJECTTABLEGet(), EVENTOBJECTTABLEIsValid(), EVENTOBJECTTABLELogicalToDisplay(), EVENTOBJECTTABLELogicalToOdbc(), EVENTOBJECTTABLENormalize(), EVENTOBJECTTABLESQLCompute()
property TABLECATALOG as %String (MAXLEN = 128) [ Calculated , SqlFieldName = TABLE_CATALOG ];
Table qualifier - always NULL in InterSystems IRIS
Property methods: TABLECATALOGCompute(), TABLECATALOGDisplayToLogical(), TABLECATALOGGet(), TABLECATALOGIsValid(), TABLECATALOGLogicalToDisplay(), TABLECATALOGLogicalToOdbc(), TABLECATALOGNormalize(), TABLECATALOGSQLCompute()
property TABLENAME as %String (COLLATION = "Upper", MAXLEN = 128) [ Calculated , SqlFieldName = TABLE_NAME , Required ];
Name of the table.
Property methods: TABLENAMECompute(), TABLENAMEDisplayToLogical(), TABLENAMEGet(), TABLENAMEIsValid(), TABLENAMELogicalToDisplay(), TABLENAMELogicalToOdbc(), TABLENAMENormalize(), TABLENAMESQLCompute()
property TABLESCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ Calculated , SqlFieldName = TABLE_SCHEMA , Required ];
Name of schema that contains the table.
Property methods: TABLESCHEMACompute(), TABLESCHEMADisplayToLogical(), TABLESCHEMAGet(), TABLESCHEMAIsValid(), TABLESCHEMALogicalToDisplay(), TABLESCHEMALogicalToOdbc(), TABLESCHEMANormalize(), TABLESCHEMASQLCompute()
property TRIGGERNAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TRIGGER_NAME , Required ];
Name of the trigger.
Property methods: TRIGGERNAMEDisplayToLogical(), TRIGGERNAMEGet(), TRIGGERNAMEIsValid(), TRIGGERNAMELogicalToDisplay(), TRIGGERNAMELogicalToOdbc(), TRIGGERNAMENormalize(), TRIGGERNAMESet()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: SQLStorage

Maps: 2

  • Map number 1 is named Master

    thismap.Global: ^oddSQL

  • Map number 2 is named rxIndex

    thismap.Global: ^rINDEXSQL

  • ^oddSQL({SchemaExact},{TableExact},{TriggerObjName})
    =
    Node Delimiter Piece Name
    TRIGGER_NAME
    21 ACTION_STATEMENT
    22 EVENT_MANIPULATION
    23 ACTION_ORDER
    29 ACTION_REFERENCE_NEW_TABLE
    30 ACTION_REFERENCE_OLD_TABLE
    ^rINDEXSQL("rv",$$UPPER({TABLE_SCHEMA}),$$UPPER({TABLE_NAME}),{TriggerObjName})
    =
    Node Delimiter Piece Name
    TableExact
FeedbackOpens in a new tab