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:
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);