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
- ACTIONCONDITION
- ACTIONORDER
- ACTIONORIENTATION
- ACTIONREFERENCENEWROW
- ACTIONREFERENCENEWTABLE
- ACTIONREFERENCEOLDROW
- ACTIONREFERENCEOLDTABLE
- ACTIONSTATEMENT
- ACTIONTIMING
- CREATED
- EVENTMANIPULATION
- EVENTOBJECTCATALOG
- EVENTOBJECTSCHEMA
- EVENTOBJECTTABLE
- TABLECATALOG
- TABLENAME
- TABLESCHEMA
- TRIGGERNAME
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
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
- %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()
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})
|
= |
|
^rINDEXSQL("rv",$$UPPER({TABLE_SCHEMA}),$$UPPER({TABLE_NAME}),{TriggerObjName})
|
= |
|