Re: Alter Table to Specify Column Ordering

If you had properly written your insert statements to begin with i.e. insert into blah (all columns) values (all values); then you would not be in this predicament.

Even though you can "re-arrange" the ordering of the columns by going thru few steps.... I would suggest you correct your old scripts and include column names in the insert statements. This will be a better solution in the long run.

Regards
/Rauf Received on Mon Dec 20 2004 - 03:59:47 CST