Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantage™

This view is similar to the All_RI_ChildrenV[X] 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_Child_Tables view while allowing more (or all) users to access the names via the All_RI_Children 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 tables for DBC.RI_Child_TablesV is DBC.ReferencingTbl.

The corresponding tables for DBC.RI_Child_TablesV[X] are:
  • DBC.AccessRights
  • DBC.Dbase
  • DBC.Owners
  • DBC.ReferencingTbls
  • 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 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 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 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.