alter table a add xxx int update a set xxx=id alter table a drop column id exec sp_rename 'a.xxx', 'id', 'column'