title: Best way to rename indexes
body: <p>I need to script (t-sql) renaming 3 indexes in a production data warehouse.</p>
  
  <p>These 3 indexes are single column indexes that are on top of foreign key columns, i.e. <code>Index 1 = Foreign Key 1</code>.</p>
  
  <p><strong>What is the best way to rename these indexes via a script?</strong></p>
  
  <p>*<strong>What "gotchas" do I have to be weary of?</strong></p>
  
  <p>I'm aware of sp_rename, is this advisable, or should I drop and re-create the indexes with the new name (time isn't an issue)?</p>