How to: Show Index Properties (Visual Database Tools)
You can display properties for an index in the Indexes/Keys dialog box.
To show index properties in the Properties window
In Object Explorer, right-click the table for the index with properties you want to see and click Design (Modify in SP1 or earlier).
From the Table Designer menu, click Indexes/Keys.
Select the index from the Selected Primary/Unique Key or Index list.
Properties are shown in the grid.
Note
You can also see an abbreviated list of index properties by selecting the index in Object Explorer. Properties are shown in the Properties window.
See Also
Other Resources
Working with Indexes (Visual Database Tools)