Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Enterprise Edition

When you expand the Indexes section, the table's indexes are displayed in such a way that each column forming part of a particular index is shown in a row of its own and there is a separate column indicating whether it is an ascending or descending index.


The type of an index is indicated by the following icons:



Non-clustered index


Clustered index created by a primary key constraint


Unique non-clustered index


XML index (available only for columns of XML type)


To view the index properties in detail, select an index and view the properties in the Properties window.


See also Creating and Modifying Indexes in Design Editor.

© 2020 Altova GmbH