15.10 - ShowTblChecksV[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

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName (UPI)

TableName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMNameI (Composite UPI)

CheckName

VARCHAR(128)

UNICODE

X(128)

TableConstraints.Name

TblCheck

VARCHAR(16000)

UNICODE

CASESPECIFIC

X(255)

TableConstraints.TableCheck

CreatorName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseNameI (UPI)

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

TableConstraints.CreateTimeStamp

VTCheckType

CHAR(1) LATIN

X(1)

TableConstraints.VTCheckType

TTCheckType

CHAR(1) LATIN

X(1)

TableConstraints.TTCheckType

The X view references these additional tables:

  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • You can use this view to query for table constraints that are defined for a database.

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

    Possible Values for TTCheckType

     

    Value

    Description

    NULL

    No transaction-time dimension

    C

    CURRENT TRANSACTIONTIME