Changing Database Column Order

Issue:

Changing the order of database table columns.

Resolution:

Have to re-create the table in order to change the order of the database column.

Right click on table -> Designers -> Re-arrange table column -> Save

Note: Make sure the “Prevent saving changes that require table re-creation” is unchecked. Change this my going to SQL Server -> Tools -> Options -> Designers.

References:

https://stackoverflow.com/questions/15781151/how-to-change-the-column-order-of-an-existing-table-in-sql-server-2008

https://learn.microsoft.com/en-us/troubleshoot/sql/ssms/error-when-you-save-table