查询一个数据库里的每个表的字段数

做个记录。

select SysObjects.Name, count(SysColumns.name)from SysObjects,SysColumns where SysObjects.XType='U' and SysColumns.id=Object_Id(SysObjects.Name) group by SysObjects.Name