get FarCry row and refobject counts

rowcounts.sql

select d1.tablename, d1.rowcnt, d2.typename, d2.num from (

SELECT 
ta.name TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
ON ta.schema_id = sc.schema_id
WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY sc.name,ta.name
) d1 left join (select typename, count(objectid) as num from refObjects group by typename) d2 on d1.tablename = d2.typename

order by d1.rowcnt desc, d2.num desc;