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 Caché, reserved for future use.
Property methods: ACTIONCONDITIONCompute(), ACTIONCONDITIONDisplayToLogical(), ACTIONCONDITIONGet(), ACTIONCONDITIONIsValid(), ACTIONCONDITIONLogicalToDisplay(), ACTIONCONDITIONLogicalToOdbc(), ACTIONCONDITIONNormalize(), ACTIONCONDITIONSQLCompute()
property ACTIONORDER as %Integer [ SqlFieldName = ACTION_ORDER , Required ];
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 Caché, 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 Caché, 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 (MAXLEN = 128) [ SqlFieldName = ACTION_STATEMENT ];
ACTION_STATEMENT is not currently used by Caché, 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
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 Caché, 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 Caché, 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 Caché, 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 Caché
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: CacheSQLStorage

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