首页 > 其他 > 详细

SSMS查看表行数以及使用空间 How to show table row count and space used in SSMS - SSMS Tutorials

时间:2019-03-07 11:44:42      阅读:311      评论:0      收藏:0      [点我收藏+]

原文:How to show table row count and space used in SSMS - SSMS Tutorials

There‘s a quick and convenient way to see row count, data and index space used in of all tables in one list with SSMS.

First, go to View and Object Explorer Details or press F7 key to enable Object Explorer Details pane.

技术分享图片

Now select Tables item under the database you want to analyze in Object Explorer. List of all tables will show in Object Explorer Details pane on the right. Right click grid header and select:

  • Data Space Used (KB)
  • Index Space Used (KB)
  • Row Count

技术分享图片

This will add new columns with those details to the list of your tables.

技术分享图片

You can copy this data for further analysis and reporting. 

SSMS查看表行数以及使用空间 How to show table row count and space used in SSMS - SSMS Tutorials

原文:https://www.cnblogs.com/lonelyxmas/p/10487865.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!