SQL: How to Move Columns Up or Down in an Existing Table

Normally using SQL Server Management Studio, this is not possible. You will be prompted that the change on the table structure won't be saved, and dropping and recreating the table is the best option.

Solution:
In SQL Server 2008, go to Tools >> Options. In the little window, click "Designer". Uncheck "Prevent saving changes that require ..."