统计数据库某用户下每个表有多少条数据

Oracle数据库：

select t.table_name,t.num_rows from user_tables t

MySQL数据库：

select table_name,table_rows from information_schema.tables  where TABLE_SCHEMA = '数据库名称'

SQLserver数据库：

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

 

SELECT a.name AS tableName, MAX(b.rows) AS cnt 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 tableName DESC

 

DB数据库：

select tabname,card from syscat.tables where tabschema = 'you table schema'

PG数据库：

vacuum ;
select sum(rowCounts) from (
select relname as TABLE_NAME, reltuples as rowCounts from pg_class where relkind = 'r' and relnamespace = (select oid from pg_namespace where nspname='public') order by rowCounts desc) s;