17.00 - TriggersV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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