15.10 - ErrorTblsV[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

ErrTblDbName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

ErrTblName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName (NUSI)

BaseTblDbName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

BaseTblName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

TVM.TVMName (NUSI)

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI:SS

ErrorTbls.CreateTimeStamp

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owner
  • DBC.RoleGrants
  • DBC.Roles
  • The following example shows base data table u2.t1 has an error table u2.ET_t1, which is created by u2:

    ==> SELECT ErrTblDbName (char(8)), 
        ErrTblName (char(8)), 
        BaseTblDbName (char(8)), 
        BaseTblName (char(8)), 
        CreatorName (char(4)),
        CreateTimeStamp
    FROM  DBC.ErrorTblsV;

    Result:

    ErrTblDbName  ErrTblName  BaseTblDbName  BaseTblName  CreatorName      CreateTimeStamp
    ------------  ----------  -------------  -----------  -----------  -------------------
    u2            ET_t1       u2             t1           u2           2006-08-28 11:47:56