把非自增的字段转换成自增字段

--删除主健
select 'alter table '+quotename(a.name)+' drop constraint ' +QUOTENAME(b.Name)
from sys.objects as a
    inner join  sys.objects as b on a.object_id=b.parent_object_id and b.type='PK'
where 
not exists(select 1 from sys.columns where object_id=a.object_id and is_identity=1) 
and a.type='U'

--新增标识列为主健，列名为ID,首先要定义好列名的唯1
select 'alter table '+quotename(name)+' add ID int identity(1,1) primary key' 
from sys.objects as a 
where 
not exists(select 1 from sys.columns where object_id=a.object_id and is_identity=1) 
and type='U'