Best would be to create a new table and copy the data but you can do it by adding a new column, updating to copy the data then dropping the old column and renaming the new.