sqlserver 字段修改

1.增加字段

alter table table_name add column_name colume_property;

2.修改字段名

sp_rename 'table_name.cloumn_name','new_column_name','column';

3.修改字段类型

alter table table_name
alter column column_name coluln_property;