title: SQL Server -- Any way to add a column and make it first column in table?
body: <p>I'm altering an existing table to add an Identity column.  That I can do, no problem.</p>
  
  <p>But I'm wanting to be sure that people who look at it in the future will see that it has the identity column added, so I really want to make it column 1. I know this is totally inconsequential to the system's operation; it's strictly for human reading.</p>
  
  <p>Does anyone know of a way to do this?  I've looked at the TSQL syntax for Alter Table and for column_definition, and don't see anything; but I'm hoping someone knows of a way to make this happen.</p>
  
  <p>FWIW, this is a one-time operation (but on many servers, so it needs to be automated), so I'm not worried whether any "trick" might go away in the future -- as long as it works now.  We're using recent versions of SQL Server Express.</p>
  
  <p>Thanks for any suggestions.</p>