SELECT
'[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS fulltable_name,
SCHEMA_NAME(t.schema_id) AS schema_name,
t.name AS table_name,
i. ROWS
FROM
sys.tables AS t
INNER JOIN sys.sysindexes AS i ON t.object_id = i.id
AND i.indid < 2
order by 4 desc
 
the result is the following picture.. (my test database)
  
 
have a nice day!
 
E2