SELECT sysobjects.name TableName,sysindexes.rows TotalNoRow
FROM sysobjects inner join sysindexes ON sysobjects.id = sysindexes.id
WHERE type = ‘U’AND sysindexes.IndId < 2
order by sysindexes.rows desc
Tagged: Number of table with row count, SQL table with row count in each table, Table and row count
Leave a Reply