alter table fragment add column x_new numeric(15,2); update fragment set x_new = x; alter table fragment drop column x; alter table fragment rename column x_new to x;