How to change index properties in SQL server

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 EditionManaged Windows VPS Hosting

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.