I have a table XYZ. It has the fields A, B, C and D. XYZ has lots of data. I need to add a column (B1) in between the columns B and C. So that the column order would become A, B, B1, C and D. Is there any direct query to add a column in between existing two columns? Bcos I cannot drop any column or recreate the same table.
Kindly help me if you have any idea.
Thanks in Advance,