16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The All_RI_ChildrenV[X] view is designed for use in a SELECT statement with a WHERE clause to narrow the selection criteria.

The All_RI_ChildrenV[X] view is similar to the RI_Child_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_Child_TablesV[X] view while allowing more (or all) users to access the names via the All_RI_ChildrenV[X] view.

Corresponding Tables

The X view references these additional tables:

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

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.