How to move column position in database table?

[CloudMonkey]

Hi,

I've added a column to a database table but by default it goes on the right hand side of the table. I need to move it to match another table's structure so that I can append tables. Please can you tell me how to move the column?

Thanks,

CM

[CloudMonkey · Accepted solution]

Can't see how to delete this post. But have now figured out the column position doesn't matter!

[v-jiascu-msft]

Hi @CloudMonkey,

You could mark your answer as solution. Others who have the same question would get the answer immediately.

Best Regards!

Dale

[zivhimmel]

Right. If for some reason it does matter to you then drop+create is the only option I can think of.