The INDEXES system view lists the index columns created on tables or views to which the current ident, or PUBLIC, has SELECT access.
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