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