--字段最多的表
select a.name,b.totle from sys.sysobjects as a
left outer join ( select id, count (*) as totle from sys.syscolumns group by id) as b
on b.id = a.id
where a.xtype = 'U'
order by totle desc
--字段用得最多的表
select name,count(*) as totle from sys.syscolumns
group by name
order by totle desc