EXT_INDEX_COLUMN

www.mimer.com/developer

EXT_INDEX_COLUMN_USAGE

The EXT_INDEX_COLUMN_USAGE system view shows on which table columns an secondary index is defined. Only indexes defined on table accessible by the current ident is shown.

Column name

Data type

Description

INDEX_CATALOG

VARCHAR(128)

Catalog name for the secondary index.

INDEX_SCHEMA

VARCHAR(128)

Schema name for the secondary index.

INDEX_NAME

VARCHAR(128)

Name of the index.

IS_UNIQUE

VARCHAR(3)

One of:
"YES" = the index may not contain duplicates
"NO" = the index may contain duplicates.

TABLE_NAME

VARCHAR(128)

Name of the table on which the index is defined.

COLUMN_NAME

VARCHAR(128)

Name of column present in index.

IS_ASCENDING

VARCHAR(3)

One of:
"YES" = the sort order of the index is ascending
"NO" = the sort order of the index is descending.

ORDINAL_POSITION

INTEGER

Ordinal position for the column within the index.

Column name	Data type	Description
INDEX_CATALOG	VARCHAR(128)	Catalog name for the secondary index.
INDEX_SCHEMA	VARCHAR(128)	Schema name for the secondary index.
INDEX_NAME	VARCHAR(128)	Name of the index.
IS_UNIQUE	VARCHAR(3)	One of: "YES" = the index may not contain duplicates "NO" = the index may contain duplicates.
TABLE_NAME	VARCHAR(128)	Name of the table on which the index is defined.
COLUMN_NAME	VARCHAR(128)	Name of column present in index.
IS_ASCENDING	VARCHAR(3)	One of: "YES" = the sort order of the index is ascending "NO" = the sort order of the index is descending.
ORDINAL_POSITION	INTEGER	Ordinal position for the column within the index.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se