Is it possible to add a column in any position?

[LarryChen]

If I use,

alter table [tableName] add [column] [type]

Then the new column will be added at the end. I wonder if it is possible in SQL server to add a new column in any position? Thanks.

[VictorN]

SQL SERVER – Change Order of Column In Database Tables
change column order in a table

[LarryChen]

SQL SERVER – Change Order of Column In Database Tables
change column order in a table

But the ways you referred to require me to drop the table and re-create the table with the desired order. But my question is actually if I can add a new column in any position without dropping/re-creating the table? Thanks.

[VictorN]

... But my question is actually if I can add a new column in any position without dropping/re-creating the table?

Well, my answer is "No, you cannot."

However, my answer could be wrong if you would find some option to add a new column in the specified position in the MSDN documentation for ALTER TABLE