select * from sys.identity_columns 查询结果包含系统自动创建的 select * from sys.identity_columns where object_id in (select object_id from sys.tables where type='u') 仅包含用户自己创建的标示列
GO SELECT B.NAME 表名, A.NAME 字段名 FROM syscolumns A,SYSOBJECTS B WHERE COLUMNPROPERTY( A.ID,A.name,'IsIdentity')=1 AND A.ID=B.ID AND B.TYPE='U'
查询结果包含系统自动创建的
select * from sys.identity_columns where object_id in (select object_id from sys.tables where type='u')
仅包含用户自己创建的标示列
SELECT B.NAME 表名,
A.NAME 字段名
FROM syscolumns A,SYSOBJECTS B
WHERE COLUMNPROPERTY( A.ID,A.name,'IsIdentity')=1
AND A.ID=B.ID AND B.TYPE='U'