👩‍💻 查詢所有Table筆數

USE [DB] 
GO 
SELECT  O.NAME '資料表名稱', P.ROWS '總數' 
FROM SYS.OBJECTS O INNER JOIN SYS.SCHEMAS S 
ON O.SCHEMA_ID = S.SCHEMA_ID 
INNER JOIN SYS.PARTITIONS P 
ON O.OBJECT_ID = P.OBJECT_ID 
WHERE (O.TYPE = 'U') AND 
(P.INDEX_ID IN (0,1)) 
ORDER BY S.NAME, O.NAME ASC; 
GO