Category: Schema
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the database where the trigger resides. |
| SubjectTableDataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the database or user in which the subject table of the trigger resides. You can use this to check for potential orphan triggers. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the table the trigger is defined against. |
| TriggerName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the trigger. |
| EnabledFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | A code that indicates whether the trigger is enabled or disabled. |
| ActionTime | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | A code that signifies when, in relation to the SQL statement, the trigger is fired. These are the values: B = Before, A = After. |
| Event | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Description of the type of action, using the following descriptions: Logon, Logoff, Logon failed. |
| Kind | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | A code that indicates whether the trigger is evaluated for: S = the statement (once), R = each row changed by the triggering action. |
| OrderNumber | SMALLINT | ---,--9 | [Optional] Specifies when triggers with same action time and event run. |
| TriggerComment | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | The optional comment for the trigger. |
| RequestText | VARCHAR(12500) UNICODE NOT CASESPECIFIC | X(12500) | The actual request text that was used to create the trigger. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | User who issued the CREATE/REPLACE TRIGGER statement. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Time the dictionary row was last updated. |
| AccessCount | INTEGER | --,---,---,--9 | The access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Time that the corresponding object was last accessed. |
| CreateTxtOverflow | CHAR(1) LATIN UPPERCASE | X(1) | Identifies that the CreateText for the object overflowed DBC.TVM when set to 'C', and the complete text is stored in DBC.TextTbl. |
| VTEventType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Records the VT qualifier on the subject table |
| TTEventType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Records the TT qualifier on the subject table |