SqlServer sysobjects_table

--这是查询所有表的信息

select * from sysobjects where xtype='U';

--这是查询表的数量

select count(*) from sysobjects where xtype='U'

--这是快速查询所有表中的数据量

SELECT  a.name ,

        b.rows

FROM    sysobjects a WITH ( NOLOCK )

        JOIN sysindexes b WITH ( NOLOCK ) ON b.id = a.id

WHERE   a.xtype = 'U'

        AND b.indid IN ( 0, 1 )

ORDER BY a.name ASC