Table Wise Rows Count

Here SQL developer need to know how grow the table size and  table wise raw pages in Database. you can easily find the total rows of specific table or all table in db.

1 – SQL Script

SELECT obj.name TableName , ind.rows TotalRows
FROM sysobjects obj INNER JOIN sysindexes ind ON (obj.id = ind.id)
WHERE obj.xtype = ‘u’ AND ind.indid < 2

2 – SQL Script

SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255
GROUP BY
t.Name, s.Name, p.Rows
ORDER BY
t.NAME , p.rows

Here are two SQL scripts to find the table rows count.