title: Composite Clustered Index in SQL Server
body: <p>I have a table with a IDENTITY Column as Primary Key (a classic ID column).</p>
  
  <p>SQL Server create automatically a Clustered Index for that Primary Key.</p>
  
  <p>My question is:</p>
  
  <ul>
  <li>Can I have a only single CLUSTERED INDEX composite with more columns?</li>
  </ul>
  
  <p>If yes, how can I drop the default clustered index and recreate a new one with this attributes.</p>
  
  <p>Thanks for your support</p>