Foreign Keys Schema Rowset - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

Foreign Keys Schema Rowset

 

Table 30: Foreign Keys Schema Rowset

Default Sort Order

Supported Restrictions

Supported Columns

FK_TABLE_SCHEMA

FK_TABLE_NAME

FK_SCHEMA_NAME

FK_TABLE_NAME

PK_SCHEMA_NAME

PK_TABLE_NAME

PK_TABLE_SCHEMA

PK_TABLE_NAME

PK_COLUMN_NAME

FK_TABLE_SCHEMA

FK_TABLE_NAME

FK_COLUMN_NAME

ORDINAL

Define Keys

OLE DB Provider for Teradata only returns a rowset if the consumer defines both:

  • Primary key of the PK_TABLE_NAME using the PRIMARY KEY clause, and
  • FK_TABLE_NAME using the REFERENCES clause
  • For example, if the consumer defines the foreign key relationship as follows, one row will be returned.

    CREATE TABLE PARENT1 (
    P1  INTEGER NOT NULL PRIMARY KEY,
    P2  INTEGER,  
    P3  INTEGER 
    );  
    CREATE TABLE CHILD1 (
    C1  INTEGER,
    C2  INTEGER,
    C3  INTEGER REFERENCES PARENT1 (P1) 
    );  

    However, if the parent table were defined as follows, no rows are returned.

    CREATE TABLE PARENT1 (
    P1  INTEGER NOT NULL,
    P2  INTEGER,
    P3  INTEGER 
    ) UNIQUE PRIMARY INDEX (P1);