Then create the new table, based on the old table but with the updated column name: CREATETABLEorig_table_name ( col_aINT, col_bINT); Then copy the contents across from the original table. INSERTINTOorig_table_name(col_a, col_b)SELECTcol_a, colbFROMtmp_table_name; Lastly, drop the ...