sql比对两个数据库的表和列

---表名比对
SELECT t.name,s.name FROM leatest.dbo.sysobjects t
full join les_server.dbo.sysobjects s on t.name=s.name
WHERE t.xtype='U' and t.category =0
--and s.xtype='U' and s.category =0
order by t.name

 

--列比较
select aa.*,bb.* from (
select ss.name,sj.name as TableName from leatest.dbo.syscolumns ss
left join leatest.dbo.sysobjects sj on ss.id=sj.id
where sj.xtype='u'
) aa
full join  (
select ss.name,sj.name as TableName from les_server.dbo.syscolumns ss
left join les_server.dbo.sysobjects sj on ss.id=sj.id
where sj.xtype='u'
) bb
on aa.TableName=bb.TableName and aa.name=bb.name