Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to move column position in database table?

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

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

    • zivhimmel's avatar
      zivhimmel
      Resolver I
      9 years ago

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

       

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

       

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

       

      Best Regards!

      Dale