17.00 - TablesV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.