如何判断表中是否有字增字段

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

posted @ 2009-06-25 16:35  空紫竹  阅读(166)  评论(0编辑  收藏  举报