1. 修改字段类型
alter table payment_bill_review alter column admitting_icd_code varchar(6)
2. 重命名
exec sp_rename 'payment_bill_review.admitting_icd_code' ,'admitting_icd9_code', 'column'
3. 删除字段
alter table icd_payment_bill_review drop column usage_type
4. 删除约束
alter table body_part_status drop constraint DF__body_part__do_no__41EEC7E6
5. 帮助信息
sp_help 'body_part_status'