How To change the column order of An Existing Table in SQL Server 2008

sql-server

Solution

I got the answer for the same , Go on `SQL Server → Tools → Options → Designers → Table and Database Designers` and unselect `Prevent saving changes that require table re-creation`

2- Open table design view and that scroll your column up and down and save your changes.

Problem

I have situation where I need to change the order of the columns/adding new columns for existing Table in SQL Server 2008. Existing column ``` MemberName MemberAddress Member_ID(pk) ``` and I want this order ``` Member_ID(pk) MemberName MemberAddress ```

Original source