title: SQL Server Column Display Order
body: <p>When you create a table via scripts it appears to just list the columns in order of creation.  It's a minor annoyance, but I like a certain method to the madness.  When I later add a column with <code>ALTER TABLE</code>, how do I make it show up in a specific place when viewing the table in interactive tools such as enterprise manager?</p>
  
  <p>ex:</p>
  
  <pre><code>Table Foo
  ---------
  FooID  
  BarID  
  Name  
  Address  
  Worth  
  </code></pre>
  
  <p>I want to </p>
  
  <pre><code>ALTER TABLE Foo  
  ADD BazID INT NULL 
  </code></pre>
  
  <p>and have <code>BazID</code> listed between <code>BarID</code> and <code>Name</code> when I use Management Studio.</p>