16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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