Viewing Indexes

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure > Viewing Table Structure >

Viewing Indexes

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.

design_indexes

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