Category: Schema
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| DataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the database where the trigger resides. |
| SubjectTableDataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the 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) | Returns the name of the table the trigger is defined against. |
| TriggerName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the trigger. |
| EnabledFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Returns a code that indicates whether the trigger is enabled or disabled. |
| ActionTime | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Returns a code to signify 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) | Returns a description of the type of action, using the following descriptions: Logon, Logoff, Logon failed. |
| Kind | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Returns 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 | Optionally specifies when triggers bearing the same action time and event executes. |
| TriggerComment | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | Returns the optional comment for the trigger. |
| RequestText | VARCHAR(12500) UNICODE NOT CASESPECIFIC | X(12500) | Returns the actual request text that was used to create the trigger. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the Teradata User who issued the CREATE/REPLACE TRIGGER statement. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Returns the date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Returns the time the dictionary row was last updated. |
| AccessCount | INTEGER | --,---,---,--9 | Returns the access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Returns the 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) | COLUMN DBC.TriggersVX.VTEventType records the VT qualifier on the subject table |
| TTEventType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | COLUMN DBC.TriggersVX.TTEventType records the TT qualifier on the subject table |