Category: Schema
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 a table, join index, or hash index. |
Version | SMALLINT NOT NULL | zzzz(9) | Returns 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) | Returns 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) | Returns the Teradata user who issued the CREATE TABLE statement. |
RequestText | VARCHAR(12500) UNICODE NOT CASESPECIFIC | X(12500) | Returns the text of the most recent data definition statement that was used to change the table, view,join index, trigger, macro, user-defined types, user-defined methods, or user defined function. |
CommentString | VARCHAR(255) UNICODE NOT CASESPECIFIC | X(255) | Returns user-supplied text or commentary on the column, database, table, view, macro, user-defined function, user-defined types, user-defined methods, stored procedure, role, profile, or user. |
ParentCount | SMALLINT NOT NULL | ---,--9 | Returns the number of parent tables for the table specified in the TVM row. |
ChildCount | SMALLINT NOT NULL | ---,--9 | Returns 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 | Returns the count of named table-level check constraint for the table. |
UnnamedTblCheckExist | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Returns an indicator for whether the table has an unnamed table-level check constraint, as follows: Y = Yes, N = No. |
PrimaryKeyIndexId | SMALLINT | ---,--9 | TablesVX.PrimaryKeyIndexId identifies the 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 | Returns the date and time that the object in the row was created. |
LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the user who last updated the dictionary row. |
LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Returns 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 | Returns the access count for the corresponding database object. |
LastAccessTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | Returns the time that the corresponding object was last accessed. |
UtilVersion | SMALLINT | -----9 | Returns the utility version count. |
QueueFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Stores 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 TablesVX.CommitOpt specifies 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 or not the table allows duplicate rows. |
TemporalProperty | CHAR(1) LATIN UPPERCASE | X(1) | DBC.TablesVX.TemporalProperty indicates whether the table/view/join index is a nontemporal, ValidTime, TransactionTime, or bi-temporal table |
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. |
SystemDefinedJI | CHAR(1) LATIN UPPERCASE | X(1) | DBC.TablesVX.SystemDefinedJI 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 etc. Y if the entry is corresponding SysJI or N otherwise. |
VTQualifier | CHAR(1) LATIN UPPERCASE | X(1) | DBC.TablesVX.VTQualifier 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) | DBC.TablesVX.TTQualifier 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 | TablesVX.PIColumnCount is the number of columns in the primary index or primary AMP index (otherwise, 0). |
PartitioningLevels | SMALLINT NOT NULL | -(5)9 | DBC.TablesVX.PartitioningLevels indicates the 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) | LoadProperty is 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 | CurrentLoadId indicates the CurrLoadID of the LDI table/join index. It is NULL for non-LDI objects. |
LoadIdLayout | CHAR(1) LATIN UPPERCASE | X(1) | LoadIdLayout indicates the RowLoadID layout type of the table. It is set to NULL for non-LDI objects, "R" when RowLoadID is recorded in the row along with the other columns and "C" when RowLoadID is recorded in a column partition. |
DelayedJI | CHAR(1) LATIN UPPERCASE | X(1) | DelayedJI is 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 | DataBlockSize is the integer value in bytes and is rounded upward to the nearest multiple of the sector size in bytes. Null is specified if not specified or if it does not apply to the object. |
FreeSpacePercent | BYTEINT | Z9% | FreeSpacePercent is the byte integer value in the range of 0 to 75, inclusive. NULL if not specified or if it does not apply to the object. |
MergeBlockRatio | BYTEINT | ZZ9% | MergeBlockRatio is the byte integer value in the range of 0 to 100,inclusive. NULL if no t specified or if it does not apply to the object. |
CheckSum | CHAR(1) LATIN UPPERCASE | X(1) | CheckSum is "N" for OFF or "Y" for ON to indicate checksum. |
BlockCompression | VARCHAR(8) UNICODE NOT CASESPECIFIC | X(8) | BlockCompression corresponds to the string token specified in the BLOCKCOMPRESSION clause. Valid values are "DEFAULT", "MANUAL", "AUTOTEMP", "NEVER", "ALWAYS" or NULL if not specified or if it does not apply to the object. |
BlockCompressionAlgorithm | VARCHAR(7) UNICODE NOT CASESPECIFIC | X(7) | BlockCompressionAlgorithm corresponds to the string token specified in the BLOCKCOMPRESSIONALGORITHM clause. Valid values are "DEFAULT","ZLIB", "ELZS_H" or NULL if not specified or if it does not apply to the object. |
BlockCompressionLevel | VARCHAR(7) UNICODE NOT CASESPECIFIC | X(7) | BlockCompressionLevel corresponds to the string token specified in the BLOCKCOMPRESSIONLEVEL clause. Valid values are "DEFAULT", "1-9" or NULL if not specified or if it does not apply to the object. |
TableHeaderFormat | CHAR(1) LATIN UPPERCASE | X(1) | TableHeaderFormat is 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) | RowSizeFormat indicates 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) | Returns name of map where the table resides. |
ColocationName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | ColocationName is 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 in conjunction with TableKind T to identify an unique table kind; TVMFlavor N is used in conjunction with TableKind 2 to identify function mapping type; NULL if it is not in use. |
FastAlterTable | CHAR(1) LATIN UPPERCASE | X(1) | Returns 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) | Returns the authorization name specified in the external security clause of the user defined function or external stored procedure. |