- SELECT
- QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]
- , SUM(sPTN.Rows) AS [RowCount]
- FROM
- sys.objects AS sOBJ
- INNER JOIN sys.partitions AS sPTN
- ON sOBJ.object_id = sPTN.object_id
- WHERE
- sOBJ.type = 'U'
- AND sOBJ.is_ms_shipped = 0x0
- AND index_id < 2
- GROUP BY
- sOBJ.schema_id
- , sOBJ.name
- ORDER BY [TableName]
Get Table Wise Row count Details from DataBase
This sql query help you list out the all table with their total rows from database