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 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.

Corresponding Tables

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.Roles
  • DBC.RoleGrants


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