<div>
I am pretty certain that you must create a new table with the columns in the order you want and then copy the data from the old table to the newly created table. Then drop the old table to make this work.
</div>


I am pretty certain that you must create a new table with the columns in the order you want and then copy the data from the old table to the newly created table. Then drop the old table to make this work.

<div>
In the end it does definitely have to be done by creating a new table, but it's still all going to be through tsql...<br />
<br />
You can do this in Management Studio, if you open a table in design view and insert the column, you can hit the button for &quot;Generate Change Script&quot;, which will give you the TSQL commands that it's going to run in order to make the change.<br />
<br />
Gives you a better idea of what's involved.
</div>


In the end it does definitely have to be done by creating a new table, but it's still all going to be through tsql...

You can do this in Management Studio, if you open a table in design view and insert the column, you can hit the button for "Generate Change Script", which will give you the TSQL commands that it's going to run in order to make the change.

Gives you a better idea of what's involved.

<div>
Note that depending on how many indexes / FKs linking to the table, that change script could be huge. &nbsp;As it's going to have to drop all of the constraints and indexes, transfer the data, and then recreate.
</div>


Note that depending on how many indexes / FKs linking to the table, that change script could be huge.  As it's going to have to drop all of the constraints and indexes, transfer the data, and then recreate.

<div>
<div class="content wysiwyg-content">
I added a column to my Sql Server Table by using T-SQL. However, I want to know can I reposition an existing column. In other words, I want to move my column I added to Column 1 position. &nbsp;Can I do that using T-SQL.?
</div>
</div>


I added a column to my Sql Server Table by using T-SQL. However, I want to know can I reposition an existing column. In other words, I want to move my column I added to Column 1 position.  Can I do that using T-SQL.?

Sql Server Table Column positioning

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.