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
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