15.10 - ShowColChecksV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Integrity

DBC

 

View Column

Data Type

Format

Source Table.Column

DataBaseName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DataBaseNameI (UPI)

TableName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMNameI (Composite UPI)

ColumnName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVFields.FieldName

ColCheck

VARCHAR(8192)

UNICODE

X(255)

TVFields.ColumnCheck

CreatorName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseNameI (UPI)

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

TVFields.CreateTimeStamp

TimeDimension

CHAR(1) LATIN

X(1)

TVFields.TimeDimension

VTCheckType

CHAR(1) LATIN

X(1)

TVFields.VTCheckType

TTCheckType

CHAR(1) LATIN

X(1)

TVFields.TTCheckType

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
  • 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 ANSI Temporal Table Support and Temporal Table Support.

    For more information about the possible values for the TimeDimension column, see Appendix A: “View Column Values.”

    Possible Values for TTCheckType

     

    Value

    Description

    A

    ANSIQUALIFIER

    Note: 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.

    Note: 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