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

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

ConstraintName

VARCHAR(128)

UNICODE

X(128)

TableConstraints.Name

ConstraintText

VARCHAR(16000)

UNICODE

CASESPECIFIC

X(255)

TableConstraints.TableCheck

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

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
  • 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