Category: Schema
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of a database. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of a table or join index. |
| IndexNumber | SMALLINT NOT NULL | ZZ9 | Internal number assigned to the index. A primary index or primary AMP index has an index number of 1. A secondary index has an index number that is a multiple of 4 between 4 and 128. |
| IndexType | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies P(NPPI), Q(PPI), A(PA), S(SI), U(unique), K(primary key), J(join index), V(value-ordered SI), H(hash-ordered ALL SI), O(value-ordered ALL SI), I(composite SI ordering column), 1(field1), 2(field2), G(geospatial NUSI). |
| UniqueFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | A code to indicate whether the index is unique. The following codes are used: Y = Yes; index is unique, N = No; index is not unique. |
| IndexName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of the reference index. |
| ColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Column names participating in an index that is accessible to the current user. |
| ColumnPosition | SMALLINT NOT NULL | Z9 | Position of the column in the index. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Table or database creator. For DBC.AllRights, the grantor of explicit rights, otherwise the user who ran the CREATE statement. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time the index was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Time the dictionary row was last updated. |
| IndexMode | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Specifies H (secondary index rows are hash distributed to the AMPs), L (secondary index rows are on the same AMP as the referenced data row), or NULL (PI or PA). If the index type is J or N, index mode is L but has no meaning. |
| AccessCount | BIGINT | --,---,---,---,---,---,--9 | The access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Time that the corresponding object was last accessed. |
| UniqueOrPK | CHAR(1) LATIN UPPERCASE | X(1) | Specifies U (unique), K (primarykey), or NULL when the unique or primarykey constraint is not associated with time dimension or the row is not for a unique or primarykey constraint description. |
| VTConstraintType | CHAR(1) LATIN UPPERCASE | X(1) | Specifies C (current), S (sequenced), N (nonsequenced), or NULL. Used for all rows on a table that do not support ValidTime, otherwise an index row. |
| TTConstraintType | CHAR(1) LATIN UPPERCASE | X(1) | Specifies C (current), S (sequenced), N (nonsequenced), or NULL. Used for all rows on a table that do not support TransactionTime, otherwise an index row. |
| SystemDefinedJI | CHAR(1) LATIN UPPERCASE | X(1) | Records whether a join index is system-defined or user-defined. Y if the entry is corresponding to a system-defined join index or NULL otherwise |
| IndexDatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Database, if any, for the index. |
| RowSizeFormat | VARCHAR(1) LATIN NOT CASESPECIFIC | X(1) | Indicates the row size; "0" for a format of up to 64KB, and "1" for a format of up to 1MB. |
| TimeZero | DATE | YYYY/MM/DD | The Timezero_date parameter specified in Primary Time Index clause of CREATE TABLE (starting time point associated with a Time Series table). |
| TimeBucketUnit | BYTEINT | -(3)9 | The timebucket_duration parameter specified in Primary Time Index clause of CREATE TABLE. Can have CAL_YEARS(1), CAL_MONTHS(2), CAL_DAYS(3),WEEKS(4), DAYS(5), HOURS(6), MINUTES(7), SECONDS(8), MILISECONDS(9), MICROSECONDS(10). |
| TimeBucketValue | SMALLINT | ---,--9 | The timebucket_duration parameter specified in Primary Time Index clause of CREATE TABLE. Time Bucket Value with TimeBuctUnit determines the time bucket size for a Time Series table. |
| TSFlags | BYTE(1) | X(2) | bit 1 - 1 a Time Series (TS) table, 0 not a TS table. bit 2 - 1 a TS table with TD_SEQNO column, 0 no TD_SEQNO. bit 3 - 1 a TS table with TD_TIMEBUCKET column, 0 no TD_TIMEBUCKET. bit 4 - 1 a TS table is defined with COLUMNS clause, 0 no COLUMNS. |