15.10 - RI_Distinct_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)

Integrity

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

ChildDB

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

ChildTable

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

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 corresponding tables for DBC.RI_Distinct_ParentsV are:

  • DBC.Dbase
  • DBC.ReferencedTbls
  • DBC.TVM
  • The corresponding tables for DBC.RI_Distinct_ParentsV[X] are:

  • DBC.AccessRights
  • DBC.Dbase
  • DBC.Owners
  • DBC.ReferencedTbls
  • DBC.RoleGrants
  • DBC.Roles
  • DBC.TVM