How to add a col in the fixed position?

How to add a col in the fixed position?Position of columns in a table doesn't matter. If you want the columns in a particular order then you can specify it correctly in the SELECT list. And there is no way to add a column in a fixed position without dropping and recreating the table. Why do you need this? What is the problem in column getting at the end of the existing ones?