Category: Schema
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 a table or join index. |
| Version | SMALLINT NOT NULL | zzzz(9) | The version count, which is incremented each time the table is altered with a data definition statement. |
| TableKind | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Type of table. |
| ProtectionType | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies F (Fallback) or N (None) to indicate whether the tables in the database are protected by the Fallback option. |
| JournalFlag | CHAR(2) LATIN NOT CASESPECIFIC NOT NULL | X(2) | Journaling in effect for the table, or the journal default for tables. Settings: first character BEFORE, second character AFTER. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The user who issued the CREATE TABLE statement. |
| RequestText | VARCHAR(12500) UNICODE NOT CASESPECIFIC | X(12500) | The text of the most recent data definition statement that was used to change the table, view,join index, trigger, macro, or user defined function. |
| CommentString | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | The user-supplied text or commentary on the column, database, table, view, macro, user-defined function, stored procedure, role, profile, or user. |
| ParentCount | SMALLINT NOT NULL | ---,--9 | The number of parent tables for the table specified in the TVM row. |
| ChildCount | SMALLINT NOT NULL | ---,--9 | The count of the referencing tables for the table. For stored procedures and external stored procedures, this field stores the number of result sets. |
| NamedTblCheckCount | SMALLINT NOT NULL | ---,--9 | The count of named table-level check constraint for the table. |
| UnnamedTblCheckExist | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Indicates whether the table has an unnamed table-level check constraint, as follows: Y = Yes, N = No. |
| PrimaryKeyIndexId | SMALLINT | ---,--9 | he Primary Key index Id for the table. It is NULL if table does not have a Primary Key. |
| RepStatus | CHAR(1) LATIN UPPERCASE | X(1) | These are the possible values: C = connected, D = defined, F = failed, S = suspended, T = terminated, I = Initiated, NULL. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time that the object in the row was created. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time the dictionary row was last updated. |
| RequestTxtOverflow | CHAR(1) LATIN UPPERCASE | X(1) | Identifies that the Request Text for the object has overflown. |
| AccessCount | BIGINT | --,---,---,---,---,---,--9 | The access count for the corresponding database object. |
| LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time that the corresponding object was last accessed. |
| UtilVersion | SMALLINT | -----9 | The utility version count. |
| QueueFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies the queuing option for the table from the values: Y = Yes (queuing option is set), N = No (queuing option is not set). |
| CommitOpt | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | The ON COMMIT option for a temporary table. Value P stands for ON COMMIT PRESERVE ROWS. Value D stands for ON COMMIT DELETE ROWS. Value N indicates the object is not a temporary table. |
| TransLog | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Specifies whether transaction journals are generated. |
| CheckOpt | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Indicates whether the table allows duplicate rows. |
| TemporalProperty | CHAR(1) LATIN UPPERCASE | X(1) | Indicates whether the table/view/join index is a nontemporal, ValidTime, TransactionTime, or bi-temporal table |
| 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. |
| SystemDefinedJI | CHAR(1) LATIN UPPERCASE | X(1) | Records whether a table level object kind is a system-defined join index or any other object such as table,view,macro,user defined join index, stored procedure and so on. Y if the entry is corresponding SysJI or N otherwise. |
| VTQualifier | CHAR(1) LATIN UPPERCASE | X(1) | Records the temporal qualifier for validtime dimension. NULL indicates that there is no ValidTime Dimension, C indicates Current ValidTime, S indicates Sequenced ValidTime, N indicates Non-Sequenced ValidTime |
| TTQualifier | CHAR(1) LATIN UPPERCASE | X(1) | Records the temporal qualifier for TransactionTime dimension. NULL is no TransactionTime Dimension, C is Current TransactionTime, S is Sequenced TransactionTime, N is Non-Sequenced TransactionTime |
| PIColumnCount | SMALLINT NOT NULL | -(5)9 | Number of columns in the primary index or primary AMP index (otherwise, 0). |
| PartitioningLevels | SMALLINT NOT NULL | -(5)9 | Number of partitioning levels (a value between 1 and 62, inclusive) or no partitioning (a value of 0). |
| LoadProperty | CHAR(1) LATIN UPPERCASE | X(1) | Set to NULL for non-LDI objects. For LDI tables, "I" indicates concurrent Load Isolation for only INSERTs, "A" for ALL DMLs, "D" for temporarily disabled and "S" for system determined for a join index defined on a LDI table. |
| CurrentLoadId | INTEGER | --,---,---,--9 | CurrLoadID of LDI table/join index. NULL for non-LDI objects. |
| LoadIdLayout | CHAR(1) LATIN UPPERCASE | X(1) | RowLoadID layout type of table. NULL for non-LDI objects, R when RowLoadID is recorded in the row with the other columns, C when RowLoadID is recorded in column partition. |
| DelayedJI | CHAR(1) LATIN UPPERCASE | X(1) | Set to NULL for non-join index entries and set to a not-null value when a JI is declared for delayed JI maintenance. |
| BlockSize | INTEGER | Z,ZZZ,ZZZ,ZZ9 | Byte integer value, rounded upward to nearest multiple of sector size in bytes. NULL if not specified or not applicable to object. For Object File System tables, this is a default setting that you cannot change. |
| FreeSpacePercent | BYTEINT | Z9% | Byte integer value in range [0, 75]. NULL if not specified or not applicable to object. For Object File System tables, this is a default setting that you cannot change. |
| MergeBlockRatio | BYTEINT | ZZ9% | Byte integer value in range [0, 100]. NULL if not specified or not applicable to object. For Object File System tables, this is a default setting that you cannot change. |
| CheckSum | CHAR(1) LATIN UPPERCASE | X(1) | N for OFF or Y for ON, to indicate checksum. For Object File System tables, this is a default setting that you cannot change. |
| BlockCompression | VARCHAR(8) UNICODE NOT CASESPECIFIC | X(8) | Corresponds to the string token specified in the BLOCKCOMPRESSION clause. Valid values are "DEFAULT", "MANUAL", "AUTOTEMP", "NEVER", "ALWAYS" or NULL if not specified or not applicable to the object. For Object File System tables, this is a default setting that you cannot change. |
| BlockCompressionAlgorithm | VARCHAR(7) UNICODE NOT CASESPECIFIC | X(7) | Corresponds to the string token specified in the BLOCKCOMPRESSIONALGORITHM clause. Valid values are "DEFAULT","ZLIB", "ELZS_H" or NULL if not specified or not applicable to the object. |
| BlockCompressionLevel | VARCHAR(7) UNICODE NOT CASESPECIFIC | X(7) | Corresponds to the string token specified in the BLOCKCOMPRESSIONLEVEL clause. Valid values are "DEFAULT", "1-9" or NULL if not specified or not applicable to the object. |
| TableHeaderFormat | CHAR(1) LATIN UPPERCASE | X(1) | A single character to describe the format of table header; "0" for "thin" format of up to 64KB, and "1" for "fat" format up to 1MB in-memory and up to 16 64KB row s on disk. |
| RowSizeFormat | VARCHAR(1) LATIN NOT CASESPECIFIC | X(1) | The row size; "0" for a format of up to 64KB, and "1" for a form at of up to 1MB. |
| MapName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the map where the table resides. |
| ColocationName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Set to NULL for contiguous Map and set to a non-null value for sparse maps. |
| TVMFlavor | CHAR(1) LATIN UPPERCASE | X(1) | TVMFlavor S is used with TableKind T to identify an unique table kind; TVMFlavor N is used with TableKind 2 to identify function mapping type; NULL if not in use. |
| FastAlterTable | CHAR(1) LATIN UPPERCASE | X(1) | Specifies T for FCA table and F and NULL for Non-FCA table |
| IncrementalRestoreEnabled | INTEGER | --,---,---,--9 | Indicates if Incremental Restore has been enabled for the table. |
| AuthName | VARCHAR(128) UNICODE UPPERCASE | X(128) | The authorization name specified in the external security clause of the user defined function or external stored procedure. |
| StorageName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The storage name specified to the Object File System table. |
| NOSCurrVersionNum | BIGINT | --,---,---,---,---,---,--9 | The current root node version number. This is null if not applicable for the TVM object (such as a view or NDS table). |
| NOSMinVersionNum | BIGINT | --,---,---,---,---,---,--9 | The oldest version number available in the table and is used during garbage cleanup. This is null if not applicable for the TVM object (such as a view or NDS table). |
| NOSVerLastUpdTimeStamp | TIMESTAMP(6) WITH TIME ZONE | YYYY-MM-DDBHH:MI:SS.S(6)Z | The last updated timestamp value corresponding to current root node version number. |
| ExplicitStorage | CHAR(1) LATIN UPPERCASE | X(1) | Specifies "T" if a storage clause is explicitly specified by the user, otherwise "F". |
| NOSObjPurgeInterval | DM | -d(4) hh:mm | The time after a delete occurs to when the actual data in Object File System table are cleared. |
| EncryptServiceType | CHAR(1) LATIN UPPERCASE | X(1) | Specifies the authorization encryption type, "1" for Azure KeyVault encryption and "2" for AWS encryption. |
| AuthStorageType | CHAR(1) LATIN UPPERCASE | X(1) | The authorization storage type, "M" for MANAGED_NOS. |
| AutoDBA | CHAR(1) | X(1) |
|
| AutoDBABits | BYTE(40) | X(80) | AutoDBA bits when the table is under AutoDBA control. Null when the table is under AutoDBA control. |
| AutoDBAStartTime | TIMESTAMP(0) | YYYY-MMDDBHH:MI:SS | Time when the table came under AutoDBA control. |