How to create a clustered unique index in SQL Server databases

Developers can create a clustered index in Microsoft SQL Server databases. In a clustered index, the physical order of the rows in the table is the same as the logical (indexed) order of the index key values. A table can contain only one clustered index. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to create a clustered index, they should follow the next steps:

1. In Object Explorer, right-click the table for which they want to create a clustered index and click Design (Modify in SP1 or earlier).

The table opens in Table Designer.

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

3. In the Indexes/Keys dialog box, click Add.

4. Select the new index in the Selected Primary/Unique Key or Index list.

5. In the grid, select Create as Clustered, and choose Yes from the drop-down list to the right of the property.

The index is created in the database when they save the table.