Primary 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

Primary Keys Schema Rowset

 

Table 32: Primary Keys Schema Rowset

Default Sort Order

Supported Restrictions

Supported Columns

TABLE_SCHEMA

TABLE_NAME

TABLE_SCHEMA

TABLE_NAME

TABLE_SCHEMA

TABLE_NAME

COLUMN_NAME

ORDINAL

PK_NAME

PRIMARY KEY Clause Required

OLE DB Provider for Teradata only returns data on tables created using the PRIMARY KEY clause.

Specify Restrictions

The consumer must specify a restriction for TABLE_NAME, otherwise an empty rowset is returned.