Indexes 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

Indexes Schema Rowset

 

Table 31: Indexes Schema Rowset

Default Sort Order

Supported Restrictions

Supported Columns

UNIQUE

TYPE

INDEX_SCHEMA

INDEX_NAME

ORDINAL_POSITION

TABLE_SCHEMA

TABLE_NAME

TABLE_SCHEMA

TABLE_NAME

INDEX_SCHEMA

INDEX_NAME

UNIQUE

TYPE

NULL_COLLATION

ORDINAL_POSITION

COLUMN_NAME

COLLATION

PAGES

Specify Restrictions

The consumer must specify a restriction for the TABLE_NAME column, otherwise IDBSchemaRowset::GetRowset returns the E_FAIL error code.

  • If the consumer has not specified a restriction for TABLE_SCHEMA, then OLE DB Provider for Teradata searches the default database for indexes that correspond to the table specified in TABLE_NAME.
  • If the consumer specifies a table as a restriction, and the user does not have privilege to access the table, then IDBSchemaRowset returns the E_FAIL error code.
  • Sort Limitation

    The rows are not correctly sorted. The sort on INDEX_NAME is case insensitive.