Category: Integrity
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database in which the table resides. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the table on which the index is built. |
| IndexName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the reference index. |
| IndexNumber | SMALLINT | ---,--9 | 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) | The Q (partitioning constraint). |
| ConstraintText | VARCHAR(16000) UNICODE CASESPECIFIC | X(16000) | The unresolved condition text of the partitioning constraint (implied constraint determined from the partitioning levels). |
| ConstraintCollation | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | 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) | Name of CHARSET_COLL collation if ConstraintCollation is not U. Otherwise NULL. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Index constraint creator. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time the constraint was created. |
| CharSetID | BYTEINT | -(3)9 | Unique number identifying the character set of the CHARSET_COLL collation. |
| SessionMode | CHAR(1) LATIN UPPERCASE | X(1) | Name of the session mode used to determine the default case sensitivity in evaluating the index constraint. |
| ResolvedCurrent_Date | DATE | YYYY/MM/DD | The last resolved value of CURRENT_DATE. |
| ResolvedCurrent_TimeStamp | TIMESTAMP(6) WITH TIME ZONE | YYYY-MM-DDBHH:MI:SS.S(6)Z | The last resolved value of CURRENT_TIMESTAMP. |