Installation guide

7. mxODBC Cursor Objects
Column Name Column Datatype Comment
NON_UNIQUE SMALLINT Indicates whether the index prohibits duplicate
values. Returns:
SQL.TRUE if the index allows duplicate values.
SQL.FALSE if the index values must be unique.
NULL is returned if the TYPE column indicates
that this row is SQL.TABLE_STAT (statistics
information on the table itself).
INDEX_QUALIFIER VARCHAR(128) The string that would be used to qualify the
index name in the DROP INDEX statement.
Appending a period (.) plus the INDEX_NAME
results in a full specification of the index.
INDEX_NAME VARCHAR(128) The name of the index. If the TYPE column has
the value SQL.TABLE_STAT, this column has
the value NULL.
TYPE SMALLINT not NULL Indicates the type of information contained in
this row of the result set:
SQL.TABLE_STAT - Indicates this row contains
statistics information on the table itself.
SQL.INDEX_CLUSTERED - Indicates this row
contains information on an index, and the index
type is a clustered index.
SQL.INDEX_HASHED - Indicates this row
contains information on an index, and the index
type is a hashed index.
SQL.INDEX_OTHER - Indicates this row
contains information on an index, and the index
type is other than clustered or hashed.
ORDINAL_POSITION SMALLINT Ordinal position of the column within the index
whose name is given in the INDEX_NAME
column. A NULL value is returned for this
column if the TYPE column has the value of
SQL.TABLE_STAT.
COLUMN_NAME VARCHAR(128) Name of the column in the index. A NULL value
is returned for this column if the TYPE column
has the value of SQL.TABLE_STAT.
ASC_OR_DESC CHAR(1) Sort sequence for the column; "A" for
ascending, "D" for descending. NULL value is
returned if the value in the TYPE column is
SQL.TABLE_STAT.
131