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