MsSQL-查詢所有資料表與資料數

SELECT S.NAME ‘結構描述’, 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;