alter table alter column <columnname> <columntype> 后面什么都不要
create table [temp] ([id] int identity)insert into [temp] default values insert into [temp] default values insert into [temp] default values insert into [temp] default values insert into [temp] default valuesalter table [temp] add temp_id intupdate [temp] set temp_id = [id]alter table [temp] drop column [id] gosp_rename '[temp].temp_id','id' goselect * from [temp]
前面我错了 alter table <tablename> add <new> <type> update table <tablenmae> set <new>=<old> alter table <tablenmae> drop column <old> alter table <tablename> add <old> <type> update table <tablenmae> set <old>=<new> alter table <tablenmae> drop column <new>
insert into [temp] default values
insert into [temp] default values
insert into [temp] default values
insert into [temp] default valuesalter table [temp] add temp_id intupdate [temp] set temp_id = [id]alter table [temp] drop column [id]
gosp_rename '[temp].temp_id','id'
goselect * from [temp]
alter table <tablename> add <new> <type>
update table <tablenmae> set <new>=<old>
alter table <tablenmae> drop column <old>
alter table <tablename> add <old> <type>
update table <tablenmae> set <old>=<new>
alter table <tablenmae> drop column <new>