全テーブルのデータ件数を一括取得する

MS SQL Server

全テーブルのデータ件数を一括取得する

http://kin-memo.hatenablog.com/entry/2018/04/06/110922

---

SELECT OBJ.name AS TableName, IND.rows

FROM sys.objects AS OBJ

JOIN sys.sysindexes AS IND

ON OBJ.object_id = IND.id AND IND.indid < 2

WHERE OBJ.type = 'U'

ORDER BY OBJ.name;

---

Postgres

全テーブルの件数を表示する

https://qiita.com/shouta-dev/items/3f9d3bf284d59874f78a

---

select relname, n_live_tup 

from pg_stat_user_tables 

where schemaname='public'

order by relname;

---