TABLE_CATALOG1

String

Always DBNull.Value

TABLE_SCHEMA2

String

Base table schema name
(table owner name)

TABLE_NAME3

String

Base table name

NON_UNIQUE

INT16

1 if index is unique, else 0

INDEX_QUALIFIER

String

Index owner name

INDEX_NAME4

String

Index name

TYPE

INT16

Index type (always ODBC index type SQL_INDEX_OTHER)

ORDINAL_POSITION

INT16

Position of the column within the set of the index’s columns, numbered from 1

COLUMN_NAME

String

Column name

ASC_OR_DSC

String

Collation. "A" for ascending, "D" for descending