xiaolizi007
11/25/2016 - 7:48 AM

IsIdentity 判断是否是自增列

IsIdentity 判断是否是自增列 #sqlserver

 ----------------------------------------------------判断是否是自增列-----------------------------

if columnproperty(object_id('table'),'col','IsIdentity')=1 
print'自增列'
else
print'不是自增列'