SQLite数据量查询

发表于 | 分类于
SQLite数据量查询

查看所有的表

1
SELECT name FROM sqlite_master WHERE type='table';

查看数据行数

生成查询各表条数的SQL

1
2
3
4
SELECT 
    'SELECT ''' || name || ''' AS table_name, COUNT(*) AS row_count FROM ' || name || ' UNION '
FROM 
    (SELECT name FROM sqlite_master WHERE type = 'table');

把查询出来的结果整体复制后 删除最后一个union 整体全选运行即可