sqlserver數(shù)據(jù)庫查詢每個表多少行數(shù)據(jù)
發(fā)布時間：2024/5/20 21:17:48 作者：Admin 閱讀：243
廣告：
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;
廣告：
相關文章
