17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.

Corresponding Tables

The X view references these additional tables:
  • DBC.AccessRights
  • DBC.Owner
  • DBC.RoleGrants
  • DBC.Roles

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