Thread: Inserting column in the middle

How can we add columns using alter class to a table and that column should not be on the last, and it should be at where or the place which we want, must be on the middle or anywhere like that

Try the post of Bhaski in the link

Note :But ur user must have proper privileges

actually no need to rearrange these columns
if at all u want to do this to my known knowledge this can be done in two steps

step1:- alter table add
();


step2:- create table
as
select from ;