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

Database

DBC

 

View Column

Data Type

Format

Source Table.Column

IndexID

SMALLINT

NOT NULL

---,--9 (explicit)

ReferencedTbls.ReferenceIdx

IndexName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

ReferencedTbls.ReferenceIdxName

ParentDB

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

ParentTable

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

ParentKeyColumn

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVFields.FieldName

ChildDB

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

ChildTable

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

ChildKeyColumn

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVFields.FieldName

InconsistencyFlag

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

ReferencedTbls.InconsistentFlag

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReferencedTbls.CreateTimeStamp

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.Roles
  • DBC.RoleGrants
  • The All_RI_ParentsV[X] view is designed for use in a SELECT statement with a WHERE clause to narrow the selection criteria. This view is similar to the RI_Parent_TablesV[X] view, but contains the database, table, and column names instead of the IDs for access control purposes.

    The administrator can control who has access to internal ID numbers by limiting the access to the RI_Parent_TablesV[X] view while allowing more (or all) users to access the names via the All_RI_ParentsV[X] view.

    InconsistencyFlag

    If the value in the InconsistencyFlag column is Y, it may be possible to validate the reference indexes that have been marked as inconsistent.