select a.name
from syscolumns a
inner join sysobjects b
on a.id = b.id
where b.name = 'YXLoanHouse' -- 表名
and columnproperty( a.id,a.name,'isidentity')=1
sqlserver 判断某个字段是否是标识
最新推荐文章于 2023-05-10 09:13:56 发布
select a.name
from syscolumns a
inner join sysobjects b
on a.id = b.id
where b.name = 'YXLoanHouse' -- 表名
and columnproperty( a.id,a.name,'isidentity')=1