title: Why can't I reorder my SQL Server columns?
body: <p>I have an old table with FKs in it. I want to add a new column. I'll want to make this new column my primary key. So I thought I could either insert that column as the first one or insert it at the end of my table and re-order my columns afterwards.</p>
  
  <p>But SQL Server Management Studio did not allow me to do that. I understand that I cannot do that, and that column order is almost completely irrelevant in SQL.</p>
  
  <p>What I want to know, is how come... I mean, I can drop a column... isn't that the same thing as adding a new one?</p>
  
  <p>I'm just trying to understand what's going on. I've had a hard time finding documentation for that also. If anyone can point me in the good direction.</p>