SQL查詢所有Table筆數

CREATE TABLE #TableInfo
(
TableName VarChar(max),
Cnt INT
);

EXEC sp_MSforeachtable 'INSERT #TableInfo select ''?'' as TableName, Count(*) as Cnt from ?';

UPDATE #TableInfo
SET TableName=REPLACE(REPLACE(REPLACE(TableName,'[dbo].',''),'[',''),']','')

SELECT * FROM #TableInfo Order By Cnt DESC

DROP TABLE #TableInfo