How to: Change Column Order (Visual Database Tools)
You can change the order of columns in Table Designer.
Changing the column order of a table may affect code and applications that depend on the specific order of columns. These include queries, views, stored procedures, user-defined functions, and client applications. Carefully consider any changes you want to make to column order before making it.
To change the column order
In Object Explorer, right-click the table with columns you want to reorder and click Design.
The table opens in Table Designer.
Select the box to the left of the column name that you want to reorder.
Drag the column to another location within the table.