Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


INDEXES


The INDEXES system view lists the index columns created on tables or views to which the current ident, or PUBLIC, has SELECT access.

Column name
Data type
Description
TABLE_CAT
VARCHAR(128)
The name of the catalog containing the table or view.
TABLE_SCHEM
VARCHAR(128)
The name of the schema containing the table or view.
TABLE_NAME
VARCHAR(128)
The name of the base table on which the index column exists.
COLUMN_NAME
VARCHAR(128)
The name of the column of the base table and index.
INDEX_NAME
VARCHAR(128)
The unique name of the index.
ORDINAL_POSITION
INTEGER
The ordinal number of the column in the index. The ordering is determined by ordering of the columns in the CREATE INDEX statement. The numbering of the columns of the index starts at 1 and increases contiguously.
NON_UNIQUE
VARCHAR(3)
One of:
"NO" = only one row is allowed in the table identified by TABLE_NAME for each combination of values in the columns of the index
"YES" = the index is not a unique index.
ASC_OR_DESC
CHAR(1)
One of:
"A" = the order of the referenced index column is ascending
"D" = the order of the referenced index column is descending.
REMARKS
VARCHAR(254)
May contain descriptive information about 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