alter table log
alter column age varchar(100)
alter table log
alter column age float not null
alter table log
add constraint IID primary key (ID)
alter table log
exec sp_rename ‘log.age’,‘ages’,‘COLUMN’;
alter table log
add grade varchar(10) not null;
drop table log