Index Information in System Views

Information on indexes is in the system views SYSINDEX, SYSIQINDEX, SYSIXCOL, and for join indexes, SYSIQJOINIXTABLE.

See Reference: Building Blocks, Tables, and Procedures > System Tables and Views for a description of these views.

• Displaying Indexes Using Stored Procedures
  You can also use the stored procedure sp_iqindex to display a list of indexes and information about them.