方法一:
if exists(select * from syscolumns where id=object_id(N'表名') and status=0x80)
print '存在标识列'
else
print '不存在标识列'
方法二:
if exists(select * from syscolumns where id=object_id(N'表名')
and COLUMNPROPERTY(id,name,'IsIdentity')=1)
print '存在标识列'
else
print '不存在标识列'