SQLsever(SQL语言)修改列名

语法：

exec sp_rename '表名.[old_column_name]','new_column_name','column';

实例：

create table food(
    id char(5) primary key,
    FoodName char(10) unique,
    price float(5),
    grade smallint
);//创建表
insert into food
 values ('001','麻婆豆腐',10.5,85);
insert into food 
 values ('002','五谷丰登',22,74);
insert into food
 values ('004','三鲜汤',2,97);
alter table food add maker char(10);//增加一个新列
exec sp_rename 'food.[chef]','maker','column';

select * from food;