How to show index properties in the Properties window in SQL server

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:

C# in Depth, 3rd EditionManaged Windows VPS Hosting

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.