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