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.

ds_indexes

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

 

ds_ic_non_clustered_index

Non-clustered index

ds_ic_clustered_primary_index

Clustered index created by a primary key constraint

ds_ic_unique_index

Unique non-clustered index

ds_ic_xml_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