PartitioningConstraintsV[X] - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Category: Integrity

Database: DBC

View Column Data Type Format Description
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) 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) Name of the table or join index with the partitioning.
IndexName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) 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 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) Specifies Q (partitioning constraint).
ConstraintText VARCHAR(16000) UNICODE CASESPECIFIC X(16000) Unresolved condition text of the partitioning constraint (implied constraint determined from the partitioning levels).
ConstraintCollation CHAR(1) LATIN UPPERCASE NOT NULL X(1) Collation to be used in evaluating the constraint:
  • E (EBCDIC)
  • A (ASCII)
  • M (MULTINATIONAL)
  • C (CHARSET_COLL)
  • J (JIS_COLL)
  • U (use the session collation)
CollationName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) CHARSET_COLL collation name if ConstraintCollation is C.

NULL if ConstraintCollation is U.

Otherwise, collation name (EBCDIC, ASCII, MULTINATIONAL, or JIS_COLL).

CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Name of the user that created the constraint.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Date and time the constraint was created.
CharSetID BYTEINT -(3)9 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 must also exist in DBC.CharTranslations.CharSetID.
SessionMode CHAR(1) LATIN UPPERCASE X(1) 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, NULL.
ResolvedCurrent_Date DATE YYYY/MM/DD 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 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 Number of currently defined combined partitions. This value can change but cannot exceed MaxCombinedPartitions.
MaxCombinedPartitions BIGINT NOT NULL -(19)9 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 Number of partitioning levels (a value between 1 and 62, inclusive).
ColumnPartitioningLevel SMALLINT NOT NULL -(5)9 The level number for the column partitioning level (a value between 1 and 62, inclusive) or no column partitioning (a value of 0).