Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


EXT_INDEXES


The EXT_INDEXES system view shows secondary indexes defined on tables that are accessible by the current ident.

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 secondary index.
TABLE_NAME
VARCHAR(128)
Name of the table on which the index is defined.
IS_UNIQUE
VARCHAR(3)
One of:
"YES" = the index may not contain duplicates
"NO" = the index may contain duplicates.



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