hi...

If you need to rearrange the columns of the table and without lose of data
you can do one thing

first you have to create one temp table with the same columns with your own order of columns. Then select the original table values and insert in to the new table and his corresponding order. Then finally drop the temp table....

CREATE TABLE temp(ENO INT, ENAME VARCHAR(20), JOB VARCHAR(20), SAL INT, ROLE_NO INT)
INSERT INTO temp (ENO,ENAME,JOB,SAL,ROLE_NO) SELECT ENO,ENAME,JOB,ROLE_NO ,SAL FROM EMP

DROP TABLE EMP

SELECT * INTO EMP FROM temp

SELECT * FROM EMP

Then finally you get the table with rearranged columns....
SELECT ENO,ENAME,JOB,ROLE_NO ,SAL FROM EMP

select * from temp


Enjoy....

__________________
"GP_Logesh..."