How do you insert a column in a database?

How do you insert a column in a database?

I want to add a column between two fields and the only option I appear to have is to add it to the end of the columns already defined. I don't see an "insert" option, only a "delete" one. Am I missing something? HOw do I insert in a specific place in a table?
thanks,
Santwana