Get list of table names and with rowscount in sql server

 SELECT TOP 200 (SCHEMA_NAME(A.schema_id) + '.' + A.Name) AS TableName  

, SUM(B.rows) AS RecordCount  

FROM sys.objects A  

INNER JOIN sys.partitions B ON A.object_id = B.object_id  

WHERE A.type = 'U'  

GROUP BY A.schema_id, A.Name

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email