I created a column and had to drop and add a column named ID with the identity value. Since I re-added the column ID after the creation of the table, this column was the last. I wanted to move the column in the first since it was an identity column for that table.
This is how I was able to change the order of the column ID
SSMS -> Tools----Options ---Designers --- Unheck Prevent saving changes that require table - recreation
Then change the column order in the table designer.
