title: Is there a clean T-SQL query I can use to verify an index has the right columns?
body: <p>I am writing a DB upgrade script that will check to see if an index has the right two columns defined.  If it doesn't, or if it only has one of them, then I will DROP it (is there a way to ALTER an index?) and then recreate it with both.</p>