17.00 - IndexConstraintsV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.