--建立测试环境
Create table TEST1
(ID Int IDENTITY(1,1),
Name Varchar(10),
Type Int
)
Create table TEST2
(ID Int,
Name Varchar(10),
Type Int
)
GO
--测试
If Exists(Select * from SysColumns Where ID=OBJECT_ID(N'TEST1') And COLUMNPROPERTY(ID,Name,'IsIdentity')=1)
Print N'有自增列'
Else
Print N'没有自增列'
GO
If Exists(Select * from SysColumns Where ID=OBJECT_ID(N'TEST2') And COLUMNPROPERTY(ID,Name,'IsIdentity')=1)
Print N'有自增列'
Else
Print N'没有自增列'
GO