Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Professional 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 with icons. Non-clustered indexes do not have an icon. The following icons are used:


ic_clustered-index        Clustered index


ic_xml-index        XML index (available only for columns of type XML)


You can rename an index, change, add, or remove columns, or modify the order directly in the table design. Indexes that have been created automatically for primary or unique keys cannot be modified.


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

© 2019 Altova GmbH