17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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 .

For more information about the possible values for the TimeDimension column, see "TimeDimension Column."

Corresponding Tables

The corresponding tables for DBC.ShowColChecksV are:
  • DBC.DBase
  • DBC.TVFields
  • DBC.TVM
The corresponding tables for DBC.ShowColChecksV[X] are:
  • DBC.DBase
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • DBC.TVFields
  • DBC.TVM

Possible Values for TTCheckType

Value Description
A ANSIQUALIFIER
The TTCheckType column returns the value A when the qualifier is ANSIQUALIFIER for column-level CHECK constraints.
NULL No transaction-time dimension
C CURRENT TRANSACTIONTIME

Possible Values for VTCheckType

Value Description
A ANSIQUALIFIER.
The VTCheckType column returns the value A when the qualifier is ANSIQUALIFIER for column-level CHECK constraints.
NULL No valid-time dimension
C CURRENT VALIDTIME
S SEQUENCED VALIDTIME
N NONSEQUENCED VALIDTIME