title: How To change the column order of An Existing Table in SQL Server 2008
body: <p>I have situation where I need to change the order of the columns/adding new columns for existing Table in SQL Server 2008.</p>
  
  <p>Existing column</p>
  
  <pre><code>MemberName
  MemberAddress
  Member_ID(pk)
  </code></pre>
  
  <p>and I want this order</p>
  
  <pre><code>Member_ID(pk)
  MemberName
  MemberAddress
  </code></pre>