17.00 - Usage Notes - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The RI_Parent_Tables view is similar to the All_RI_Parents view, but contains the IDs of databases, tables, and columns instead of the names for access control purposes.

The administrator can control who has access to internal ID numbers by limiting the access to the RI_Parent_Tables view while allowing more (or all) users to access the names via the All_RI_Parents view.

Some of the column values show information related to a Teradata temporal table or an ANSI temporal table. For more information about these tables, see Teradata Vantage™ ANSI Temporal Table Support , B035-1186 and Teradata Vantage™ Temporal Table Support , B035-1182 .

Corresponding Tables

The corresponding table for DBC.RI_Parent_TablesV is DBC.ReferencedTbls.

The corresponding tables for DBC.RI_Parent_TablesV[X] are:
  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.ReferencedTbls
  • DBC.RoleGrants
  • DBC.Roles

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.

Possible Values for TTFKType

Value Description
C Current foreign key
N Nonsequenced foreign key
NULL A child table is a nontemporal table or a table that does not support TransactionTime
S Sequenced foreign key

Possible Values for TTPKType

Value Description
C Current parent key
S Sequenced parent key
N Nonsequenced parent key
NULL If the parent table is a nontemporal table or the table does not support either ValidTime or TransactionTime

Possible Values for VTFKType

Value Description
A ANSIQUALIFIER
The Teradata temporal valid-time tables are compatible with ANSI valid-time tables, however to use ANSI temporal tables requires that the session temporal qualifier for systems using Teradata temporal tables be explicitly set to ANSIQUALIFIER.
C Current foreign key
N Nonsequenced foreign key
P Referential integrity constraint for ANSI Temporal tables. Temporal constraints can be defined for valid-time period column names with the special PERIOD keyword.
R Temporal relationship constraint (TRC) referential integrity
S Sequenced foreign key
NULL The child table is non-temporal or does not support ValidTime.

Possible Values for VTPKType

Value Description
A ANSIQUALIFIER
C Current parent key
S Sequenced parent key
N Nonsequenced parent key
NULL If the parent table is a nontemporal table or the table does not support either ValidTime or TransactionTime
P Referential integrity constraint for ANSI Temporal tables. Temporal referential constraints can be defined for valid-time period column in temporal tables by specifying the valid-time derived PERIOD column names with the special PERIOD keyword.