Tuesday, January 4, 2011

Change index from clustered to nonclustered in SQL Server 2008

  1. Open the database in SQL Server Management Studio.
  2. Right-click on the table that has the clustered index and select Design.
  3. Right click on a blank space on the design view and select Indexes/Keys from the context menu.
  4. Select the index that you want to modify in the list on the left.
  5. Change the value of the property Create As Clustered from Yes to No.
  6. Click close, then save the table design view. 


Post a Comment