Getting Information About Tables and Indexes

Each index—including composite indexes—is represented by one row in sysindexes.

For information about the order of the data retrieved through indexes and the effects of an SAP ASE-installed sort order, see the order by clause.

For information about a table’s indexes, execute sp_helpindex. For information about index partitions, you can also execute sp_helpartitions.

Each index partition and data partition is represented by one row in syspartitions.