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