When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to change index properties, they should follow the next steps:

C# in Depth, 3rd Edition

1. In Object Explorer, right-click the table they want to open and click Design (Modify in SP1 or earlier).

2. From the Table Designer menu, click Indexes/Keys.

3. Select the index from the Selected Primary/Unique Key or Index list.

4. Change properties in the grid.

Their changes are saved to the database when they save the table.