Column values may show information related to a Teradata temporal table or an ANSI temporal table.
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 |