sqlserver数据库查询每个表多少行数据

SELECT 
 t.NAME AS TableName,
 SUM(p.rows) AS RowCounts
FROM 
 sys.tables t
INNER JOIN 
 sys.partitions p ON t.object_id = p.object_id
WHERE 
 t.is_ms_shipped = 0
GROUP BY 
 t.NAME
ORDER BY 
 RowCounts DESC;

分享到： QQ空间 微信 新浪微博