查找数据库中具有相同表结构的表

前几天一个QQ群中有人问到这个问题，当时写的就记录下来了，估计以后也有可能会用到，免的到时候再写了，也拿出来分享一下

select b.*
from (
  select columnsall,COUNT(*) bs
  from (
    select id,name,substring((select ','+name+CAST(xtype as varchar(10)) from syscolumns where id=a.id for xml path('')),2,100) columnsall 
    from sysobjects a  where xtype='u' 
    ) a
  group by columnsall having COUNT(*)>1) a
inner join (select id,name,substring((select ','+name+CAST(xtype as varchar(10)) from syscolumns where id=a.id for xml path('')),2,100) columnsall  from sysobjects a  where xtype='u'  ) b on a.columnsall=b.columnsall