15.10 - AssociationV[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)

Operations

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

EventNum

INTEGER

NOT NULL

--,---,---,--9 (explicit)

DBCAssociation.EventNum

Original_DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

DBCAssociation.Original_DatabaseName

Original_TableName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

DBCAssociation.Original_TVMName

Original_TableKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

DBCAssociation.Original_TableKind

Original_Version

SMALLINT

NOT NULL

---,--9 (explicit)

DBCAssociation.Original_Version

Original_ProtectionType

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

DBCAssociation.Original_ProtectionType

Original_JournalFlag

CHAR(2) LATIN

NOT CASESPECIFIC

NOT NULL

X(2)

DBCAssociation.Original_JournalFlag

Original_CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

DBCAssociation.Original_CreatorName

Original_CommentString

VARCHAR(255)

UNICODE

NOT CASESPECIFIC

X(255)

DBCAssociation.Original_CommentString

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owner
  • DBC.RoleGrants
  • DBC.Roles
  • The Association view contains information about entities that were restored using the Archive and Recovery COPY utility. If a copied object is subsequently dropped, the information is deleted and is no longer available.

    Possible Values for Original_JournalFlag

     

    Value

    Description

    N

    No Journal

    S

    Single Journal

    D

    Dual Journal

    L

    Local AFTER journal (non used for BEFORE)

    Possible Values for Original_TableKind

     

    Value

    Description

    T

    Data Table

    V

    View

    M

    Macro

    J

    Journal Table

    I

    Join Index Table

    P

    Stored Procedure

    G

    Trigger

    F

    Scalar UDF

    A

    Aggregate UDF

    N

    Hash Index Table

    U

    User-defined Type

    H

    Instance or Constructor Method

    E

    External Stored Procedure

    R

    Table Function

    X

    Authorization

    The following SELECT statement selects information about tables copied into the Personnel database:

    ==> SELECT Original_DatabaseName,Original_TableName,TableName
    FROM DBC.AssociationV WHERE DatabaseName = ’Personnel’;

    Result:

    Original_DatabaseName   ­Original_TableName     ­TableName
    ---------------------   ------------------     -----------
    OldPersonnel            Empl_Addr              Emp_Address
    Personnel2              Empl_Dept              Empl_Dept

    For more information on recovery control, see the following:

  • Database Administration
  • Teradata Archive/Recovery Utility Reference