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:
|
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). |