Change Column Order in a Table SQL Server

This task cannot be performed using Transact-SQL statements.

Using SQL Server Management Studio

To change the column order


1. In Object Explorer, right-click the table with columns you want to reorder and click 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.

Friends, If you like this post, please share with your friends on Facebook and Google+ and recommend us on Google using the g+1 button on the top right hand corner.