1、将fruits表下字段f_id修改为字段id:
exec sp_rename 'fruits.[f_id]','id','column';
2、查看表fruits是否存在:
select count(*) from sysobjects where type='U' and name='fruits';
1、将fruits表下字段f_id修改为字段id:
exec sp_rename 'fruits.[f_id]','id','column';
2、查看表fruits是否存在:
select count(*) from sysobjects where type='U' and name='fruits';