T-SQL for changing table column order
Once a table is created, the ordinal position of the columns is fixed. This is especially problematic for large data warehouse tables, where new columns are expected to be added over time.
The only solution currently to re-order columns is to drop and recreate the table (or let the SSMS designer do this for you), but this is often not feasible for a large, highly used table, and it cannot be easily scripted.
Please add some ALTER syntax that will allow changing column order.
Steven Hibble commented
Although this would be a nice-to-have metadata operation, I think the workaround is probably all you need. Give your table a view. Select the columns in the order that you want.