title: SQL Server: how to write an alter index statement to add a column to the unique index?
body: <p>I have a <code>UNIQUE, NON CLUSTERED</code> index on a table that is currently using 4 columns for the index. </p>
  
  <p>I want to create an alter script that can merely add another column to this index. The new column type is <code>varchar</code>. </p>
  
  <p>The database is SQL Server 2005. </p>
  
  <p>Thanks in advance. </p>