Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

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.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX