16.20 - IndexConstraintsV[X] - 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

Category: Integrity

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database in which the table resides.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the table on which the index is built.
IndexName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the reference index.
IndexNumber SMALLINT ---,--9 IndexConstraintsVX.IndexNumber is the internal number assigned to the associated index, if any. This field is 1 for a primary index or primary AMP index. This field is NULL if the partitioning is not associated with an index.
ConstraintType CHAR(1) LATIN UPPERCASE NOT NULL X(1) IndexConstraintsVX.ConstraintType is Q (partitioning constraint).
ConstraintText VARCHAR(16000) UNICODE CASESPECIFIC X(16000) IndexConstraintsVX.ConstraintText is the unresolved condition text of the partitioning constraint (implied constraint determined from the partitioning levels).
ConstraintCollation CHAR(1) LATIN UPPERCASE NOT NULL X(1) IndexConstraintsVX.ConstraintCollation is the collation to be used in evaluating the constraint: E (EBCDIC), A (ASCII), M (MULTINATIONAL), C (CHARSET_COLL), J (JIS_COLL), or U (use the session collation).
CollationName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the CHARSET_COLL collation. If ConstraintCollation is not U, it is the constraint collation name; otherwise, the value is NULL.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Index constraint creator.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS IndexConstraintsVX.CreateTimeStamp is the date and time the constraint was created.
CharSetID BYTEINT -(3)9 Returns a number uniquely identifying the character set of the CHARSET_COLL collation.
SessionMode CHAR(1) LATIN UPPERCASE X(1) Returns the name of the session mode used to determine the default case sensitivity in evaluating the index constraint.
ResolvedCurrent_Date DATE YY/MM/DD Returns the last resolved value of CURRENT_DATE.
ResolvedCurrent_TimeStamp TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Returns the last resolved value of CURRENT_TIMESTAMP.