17.00 - PartitioningConstraintsV[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) PartitioningConstraintsVX.DatabaseName is the name of the database in which the table or join index with the partitioning resides.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) PartitioningConstraintsVX.TableName is the name of the table or join index with the partitioning.
IndexName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) PartitioningConstraintsVX.IndexName is the name of the associated index, if any. This field is NULL if there is no associated index or the index does not have a name.
IndexNumber SMALLINT ---,--9 PartitioningConstraintsVX.IndexNumber is the internal number assigned to the associated index, if any. This field is 1 for a primary index. This field is 0 if the partitioning is not associated with an index.
ConstraintType CHAR(1) LATIN UPPERCASE NOT NULL X(1) PartitioningConstraintsVX.ConstraintType is Q (partitioning constraint).
ConstraintText VARCHAR(16000) UNICODE CASESPECIFIC X(16000) PartitioningConstraintsVX.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) PartitioningConstraintsVX.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) PartitioningConstraintsVX.CollationName is the CHARSET_COLL collation name if ConstraintCollation is C; it is NULL if ConstraintCollation is U; otherwise, it is the collation name (EBCDIC, ASCII, MULTINATIONAL, or JIS_COLL).
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) PartitioningConstraintsVX.CreatorName is the name of the user that created the constraint.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS PartitioningConstraintsVX.CreateTimeStamp is the date and time the constraint was created.
CharSetID BYTEINT -(3)9 PartitioningConstraintsVX.CharSetID is a number identifying the character set of the CHARSET_COLL collation, if this collation is used; otherwise, NULL. If the character set is user-defined, this ID should also exist in DBC.CharTranslations.CharSetID.
SessionMode CHAR(1) LATIN UPPERCASE X(1) PartitioningConstraintsVX.SessionMode is the name of the session mode used to determine the default case sensitivity in evaluating the index constraint: A (ANSI), T (Teradata). For constraints not involving comparison of character data, it is NULL.
ResolvedCurrent_Date DATE YY/MM/DD PartitioningConstraintsVX.ResolvedCurrent_Date is the last reconciled date if the object is a table or join index that is defined using DATE or CURRENT_DATE; otherwise, NULL.
ResolvedCurrent_TimeStamp TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z PartitioningConstraintsVX.ResolvedCurrent_Timestamp is the last reconciled timestamp if the object is a table or join index that is defined using CURRENT_TIMESTAMP; otherwise, NULL.
DefinedCombinedPartitions BIGINT NOT NULL -(19)9 PartitioningConstraintsVX.DefinedCombinedPartitions indicates the number of currently defined combined partitions. This value can change as long as it does not exceed MaxCombinedPartitions.
MaxCombinedPartitions BIGINT NOT NULL -(19)9 PartitioningConstraintsVX.MaxCombinedPartitions indicates the maximum number of combined partitions allowed. This value is greater than or equal to DefinedCombinedPartitions. This value cannot change for a nonempty table.
PartitioningLevels SMALLINT NOT NULL -(5)9 PartitioningConstraintsVX.PartitioningLevels indicates the number of partitioning levels (a value between 1 and 62, inclusive).
ColumnPartitioningLevel SMALLINT NOT NULL -(5)9 PartitioningConstraintsVX.ColumnPartitioningLevel indicates the level number for the column partitioning level (a value between 1 and 62, inclusive) or no column partitioning (a value of 0).