Lists information about indexes.
sp_iqindex [table_name='tablename' ],
[column_name='columnname' ],[table_owner='tableowner' ]
sp_iqindex_alt [table_name='tablename' ],
[column_name='columnname' ],[table_owner='tableowner' ]
Displays information about indexes in the database. Specifying one of the parameters returns the indexes from only that table, column, or tables owned by the specified user. Specifying more than one parameter filters the results by all of the parameters specified. Specifying no parameters returns all indexes for all tables in the database.
Column name |
Description |
---|---|
table_name |
The name of the table |
table_owner |
The owner of the table |
column_name |
The name of the column; multiple names can appear in a multicolumn index |
index_type |
The abbreviated index type (for example, HG, LF) |
index_name |
The name of the index |
unique_index |
'U' indicates the index is a unique index; otherwise, 'N' |
location |
TEMP = IQ temporary store, MAIN = IQ store, SYSTEM = catalog store |
remarks |
User comments added with the COMMENT statement |
sp_iqindex always produces one line per index. sp_iqindex_alt produces one line per index per column if there is a multicolumn index.