15.10 - TablesV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

DataBaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

Version

SMALLINT

NOT NULL

zzzz(9) (explicit)

TVM.Version

TableKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

TVM.TableKind

ProtectionType

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

TVM.ProtectionType

JournalFlag

CHAR(2) LATIN

UPPERCASE

NOT NULL

X(2)

TVM.JournalFlag

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

RequestText

VARCHAR(12,500)

UNICODE

X(255)

TVM.RequestText

CommentString

VARCHAR(255)

UNICODE

X(255)

TVM.CommentString

ParentCount

SMALLINT

NOT NULL

---,--9

TVM.ParentCount

ChildCount

SMALLINT

NOT NULL

---,--9

TVM.ChildCount

NamedTblCheckCount

SMALLINT

NOT NULL

---,--9

TVM.NamedTblCheckCount

UnnamedTblCheckExist

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

TVM.UnnamedTblCheckExist

PrimaryKeyIndexId

SMALLINT

---,--9(explicit)

TVM.PrimaryKeyIndexId

RepStatus

CHAR(1) LATIN

UPPERCASE

X(1)

TVM.TblStatus

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

TVM.CreateTimeStamp

LastAlterName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

LastAlterTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

TVM.LastAlterTimeStamp

RequestTxtOverflow

CHAR(1) LATIN

X(1)

TVM.RequestTxtOverflow

AccessCount

INTEGER

--,---,---,--9

ObjectUsage.UserAccessCnt

LastAccessTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ObjectUsage.LastAccessTime
Stamp

UtilVersion

SMALLINT

-----9 (explicit)

TVM.UtilVersion

QueueFlag

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

TVM.QueueFlag

CommitOpt

CHAR(1) LATIN

NOT NULL

X(1)

TVM.CommitOpt

TransLog

CHAR(1) LATIN

NOT NULL

X(1)

TVM.TransLog

CheckOpt

CHAR(1) LATIN

NOT NULL

X(1)

TVM.CheckOpt

TemporalProperty

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.TemporalProperty

ResolvedCurrent_Date

DATE

YY/MM/DD

TVM.ResolvedCurrent_Date

ResolvedCurrent_TimeStamp

TIMESTAMP(6) WITH TIME ZONE

YYYY-MM-DDBHH:MI:SS.S(F)Z

TVM.ResolvedCurrent_Time
Stamp

SystemDefinedJI

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

JI

VTQualifier

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.VTQualifier

TTQualifier

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.TTQualifier

PIColumnCount

SMALLINT

NOT NULL

ZZZZ9 (explicit)

TVM.PIColumnCount

PartitioningLevels

SMALLINT

NOT NULL

ZZZZ9 (explicit)

TVM.PartitioningLevels

LoadProperty

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.LoadProperty

CurrentLoadId

INTEGER

--,---,---,--9

TVM.CurrentLoadId

LoadIdLayout

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.LoadIdLayout

DelayedJI

Note: Reserved for future use.

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X (1)

TVM.DelayedJI

 

Note: The DBC.TVM table contains one row for each table, view, stored procedure, join index, macro, UDT, UDM, or UDF.

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • For information about the possible values for JournalFlag or TableKind columns, see Appendix A: “View Column Values.”

    Some of the column values show information related to a Teradata temporal table or an ANSI temporal table. For more information about these tables, see ANSI Temporal Table Support and Temporal Table Support.

    CurrentLoadId

    A positive, even integer that indicates the last committed load value for a load isolated table or join index. Its initial value is 0 and it is incremented by 1when a load is committed. This column is NULL for objects that are not load isolated.

    Possible Values for LoadIdLayout

     

    Value

    Description

    NULL

    Tables that are not load isolated.

    R

    Load isolated table with row partitioning or with no partitioning.

    C

    Load isolated table with column partitioning.

    Possible Values for LoadProperty

     

    Value

    Description

    NULL

    Tables or join indexes that are not load isolated.

    I

    Concurrent load isolation for INSERTs only on a load isolated table.

    A

    Concurrent load isolation for all Data Manipulation Language statements on a load isolated table.

    D

    Temporarily disabled the concurrent load isolation on a load isolated table.

    S

    A join index defined on a load isolated table.

    Possible Values for PrimaryKeyIndexId

     

    Value

    Description

    1

    Primary key is implemented using a unique primary index for the table.

    Multiple of 4 (that is, a number between 4 and 128)

    Primary key is implemented using a unique secondary index for the table. The number is the index ID for the unique secondary index.

    NULL

    Primary key is not defined for the table.

    Possible Values for PIColumnCount

    PIColumnCount is set to the number of columns in the primary index or primary AMP index. 0 indicates there is neither a primary index nor a primary AMP index.

    Note: For a NoPI table, TableKind is 'O' if the table is not partitioned and is 'T' if the table is partitioned. For a join index, TableKind is 'I'.

    To determine if a table or join index (with a nonzero PIColumnCount) has a primary index or a primary AMP index, the DBC.IndicesV[X] system views can be queried. If PIColumnCount is zero, the table or join index has neither a primary index nor a primary AMP index (that is, it is NoPI) and there are no rows in the DBC.IndicesV[X] views with an IndexNumber of 1. Note that a hash index always has a primary index.

    Possible Values for PartitioningLevels

     

    Value

    Description

    Between 1 and 62 (inclusive)

    The number of partitioning levels for the table or join index.

    0

    The table or join index is not partitioned.

    Possible Values for ResolvedCurrent_TimeStamp and ResolvedCurrent_Date

  • This is the last reconciled timestamp or date if the object is a join index or a table that is defined using:
  • CURRENT_TIMESTAMP
  • CURRENT_DATE or DATE
  • Either the partition, JI definition, or temporal table has a system-defined join index.

  • NULL in all other cases.
  • Possible Values for SystemDefinedJI

     

    Value

    Description

    Y

    The entry is corresponding to a system-defined join index.

    NULL

    Any other objects in the system.

    RequestText

    The RequestText data reflects the definitions specified by the user. This may not always match the data returned by the SHOW TABLE statement, which reflects the reconstructed definitions as they exist in the Data Dictionary.

    For example, when obsolete syntax that is still supported is converted internally to current syntax, RequestText returns the submitted (obsolete) syntax, while SHOW TABLE returns the converted (current) syntax.

    If the table is renamed, the RequestText still contains the old table name. The new table name is not put in the RequestText.

    TemporalProperty

     

    Value

    Description

    S

    A system-versioned system-time table.

    U

    A bitemporal (system-versioned system-time and valid-time) table.

    W

    A nontemporal table that contains a system-time derived period column but that is not system versioned.

    X

    A valid-time temporal table that contains a system-time derived period column but that is not system versioned.

    Version and UtilVersion

    The UtilVersion column may be zero or null for tables created prior to V2R6.0. For tables created in V2R6.0 or later, both Version and UtilVersion are initially one.

    The following table shows when the UtilVersion column is modified, and how it’s modified:

     

    UtilVersion Current Value

    Data Definition Change

    New Value or UtilVersion

    Any value

    Significant change (by an ALTER TABLE statement) to keep an archive from being restored or copied.

    = Version

    NULL or zero

    Not significant

    Version -1

    Any other value

    Not significant

    No change

    The Version column is increased by one for any data definition change other than enabling or disabling journaling for the table. Version in the above table is the version after it’s been incremented.

    The following table shows how the UtilVersion column is checked when selected partitions are restored or copied:

     

    UtilVersion Value

    Requirements

    NULL or zero

    The Version of the archive must match the Version of the table

    Any other value

    If the archive UtilVersion is zero, the Version of the Archive must match the UtilVersion of the table; otherwise, the UtilVersion column of the archive must equal the UtilVersion of the table

    Note: To restore or copy selected partitions, the table must already exist.

    The following SELECT statement displays information about tables, views, and macros in the Personnel database:

    ==> SELECT TableName,CreatorName,TableKind,ProtectionType FROM DBC.TablesV WHERE DatabaseName = ’Personnel’ ;

    The query returns the following result:

    TableName          ­CreatorName   ­TableKind   ­ProtectionType
    ------------       -----------   ---------   --------------
    NewEmp             GREENE           M        F
    EmployeeInfo       GREENE           V        F
    Employee           DBC              T        F
    Department         DBC              T        F
    Project            JONES            T        F
    Charges            JONES            T        F

    For more information about primary indexes and partitioning levels, see SQL Data Definition Language.