查询库中所有的表名及数据量

sql代码直接执行即可
sqlserver查询库中所有的表名及数据量

SELECT
	a.name,
	b.rows 
FROM
	sysobjects AS a
	INNER JOIN sysindexes AS b ON a.id = b.id 
WHERE
	( a.type = 'u' ) 
	AND ( b.indid IN ( 0, 1 ) ) 
ORDER BY
	b.rows DESC;

sqlserver查询库的数据量

SELECT   SUM(记录条数) AS 总记录数
FROM      (SELECT   TOP (10000) a.name AS 表名, MAX(b.rows) AS 记录条数
                 FROM      sys.sysobjects AS a INNER JOIN
                                 sys.sysindexes AS b ON a.id = b.id
                 WHERE   (a.xtype = 'u')
                 GROUP BY a.name
                 ORDER BY 记录条数 DESC) AS t1;
SELECT   a.name AS 表名, MAX(b.rows) AS 记录条数
FROM      sys.sysobjects AS a INNER JOIN
                sys.sysindexes AS b ON a.id = b.id
WHERE   (a.xtype = 'u') 
GROUP BY a.name HAVING MAX(b.rows)>0
ORDER BY 记录条数 DESC

oracle查询库中所有表名及数据量，库名改成自己的库名

SELECT DISTINCT
	t.table_name,
	t.num_rows
FROM
	all_tables t
	LEFT JOIN all_tab_columns C ON c.table_name = t.table_name 
WHERE
	t.Owner = '库名'

如果oracle查不出数据，可能是因为近期更新了oracle的数据导致oracle没有手机统计数据信息，可以手动收集下，具体可以执行下我的另一篇文章的sql,链接如下
num_rows为NULL时，进行Oracle收集统计信息