Some of the column values show information related to a Teradata temporal table or an ANSI temporal table. For more information about these tables, see Teradata Vantage™ ANSI Temporal Table Support , B035-1186 and Teradata Vantage™ Temporal Table Support , B035-1182 .
Corresponding Tables
The X view references these additional tables:
- DBC.AccessRights
- DBC.DBase
- DBC.Owners
- DBC.RoleGrants
- DBC.Roles
- DBC.TriggersTbl
- DBC.TVM
Possible Values for Event
Value | Description |
---|---|
U | Update |
I | Insert |
D | Delete |
Possible Values for VTEventType
Value | Description |
---|---|
A | ANSIQUALIFIER ANSI temporal tables require that the session temporal qualifier for systems using Teradata temporal tables be explicitly set to ANSIQUALIFIER.
|
C | CURRENT VALIDTIME |
N | NONSEQUENCED VALIDTIME |
NULL | No valid-time dimension |
S | SEQUENCED VALIDTIME |
Possible Values for TTEventType
Value | Description |
---|---|
A | ANSIQUALIFIER. ANSI temporal tables require that the session temporal qualifier for systems using Teradata temporal tables be explicitly set to ANSIQUALIFIER.
|
C | CURRENT TRANSACTIONTIME |
N | NONSEQUENCED TRANSACTIONTIME |
NULL | No transaction-time dimension |
S | SEQUENCED TRANSACTIONTIME |
T | Nontemporal to indicate that transaction-time is ignored even though the table supports a transaction-time dimension |