Select Distinct sysobj.name From dbo.sysobjects sysobj Inner Join dbo.syscolumns syscol On sysobj.id=syscol.id where sysobj.xtype='U'
and COLUMNPROPERTY(syscol.id,syscol.name,'IsIdentity')=1
Select Distinct sysobj.name From dbo.sysobjects sysobj Inner Join dbo.syscolumns syscol On sysobj.id=syscol.id where sysobj.xtype='U'
and COLUMNPROPERTY(syscol.id,syscol.name,'IsIdentity')=1
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2009/06/25/1511085.html