SQL SERVER 所有資料表的筆數

雖然可以用迴圈去跑所有資料表筆數
不過實在太麻煩了
SQL SERVER 可以透過 sysobjects 和 sysindexes 來查詢

SELECT sysobjects.[name], max(sysindexes.[rows]) AS TableRows 
FROM sysindexes INNER JOIN sysobjects ON sysindexes.[id] = sysobjects.[id] 
WHERE sysobjects.xtype = 'U' GROUP BY sysobjects.[name] ORDER BY sysobjects.[name]