How to change the order of columns in SQL?

In order to maintain the order of columns in SQL we require 2 steps

Disable the “Prevent saving changes that require the table re-creation“

1. Open SQL Server Management Studio.
2. On the Tools menu, click Options.
3. In the navigation pane of the Options window, click Designers.
4. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

To change the column order

1. In Object Explorer, right-click the table with columns you want to reorder and select Design.
2. Select the box to the left of the column name that you want to reorder.
3. Drag the column to another location within the table.

Here is the quick video