One way (maybe the only way) would be to recreate the table. You could do that by first creating the new table with the columns in the order you want them. Then insert the rows of the old table into the new table (using "Insert into table2 (col1,col2..) select col1,col2.. from table1"). Then rename or drop the old table. Then rename the new table. You will need to recreate the indexes, permissions, contraints, and triggers as well.
Last Wiki Answer Submitted: November 9, 2005 9:00 am by Randym1,740 pts.