You are here:Home » tsql » Return Row Count of all tables

Return Row Count of all tables

SELECT object_name(id),rows FROM sysindexes WHERE indid < 2
and id in (select id from sys.sysobjects )
order by rows desc