When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to view index properties, they should follow the next steps:
1. In Object Explorer, right-click the table for the index with properties they want to see and click Design (Modify in SP1 or earlier).
From the Table Designer menu, click Indexes/Keys.
2. Select the index from the Selected Primary/Unique Key or Index list.
3. Properties are shown in the grid.