获取MSSQL使用自增列(标识列)的表信息


select   * from sysobjects a left join  syscolumns  b on a.id=b.id
  where   columnproperty(b.id,b.name, 'IsIdentity') = 1 
  and a.xtype='u'