Sqlserver新增自增列
时间:2021-07-01 10:21:17
帮助过:25人阅读
exists(
select *
from syscolumns
where id=object_id(
‘表名‘) and name=
‘列名‘)
begin
alter table 表名 drop column 列名 ;
end
alter table 表名 add 列名 int identity(
1,
1);
Sqlserver新增自增列
标签:style add span ble sel object column code object_id