Skip to main content

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

Comments