SQL SERVER查询数据库所有表的大小，按照记录数降序排列，
SELECT B.NAME,A.ROW_COUNT FROM SYS.DM_DB_PARTITION_STATS A,
SYS.OBJECTS B
WHERE A.OBJECT_ID=B.OBJECT_ID
AND A.INDEX_ID<=1
AND B.TYPE='U'AND A.ROW_COUNT>8000
ORDER BY ROW_COUNT DESC
http://www.htsjk.com/Sql_Server/39909.html
www.htsjk.Com
true
http://www.htsjk.com/Sql_Server/39909.html
NewsArticle
SQL SERVER查询数据库所有表的大小，按照记录数降序排列， SELECT B.NAME,A.ROW_COUNT FROM SYS.DM_DB_PARTITION_STATS A, SYS.OBJECTS B WHERE A.OBJECT_ID=B.OBJECT_ID AND A.INDEX_ID=1 AND B.TYPE='U'AND A.ROW_COUNT8000 ORDER BY...
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。