Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "SQLServer how to view the amount of data of each table in a database", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and learn "SQLServer how to view the amount of data of each table in a database" this article.

In the target database, create procedure.

CREATE PROCEDURE [dbo]. [sys_viewTableSpace]

AS

BEGIN

SET NOCOUNT ON

CREATE TABLE [dbo]. # tableinfo (

Table name [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

Number of records [int] NULL

Reserved space [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

Use Space [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

Index footprint [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

Unused space [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

)

Insert into # tableinfo (table name, number of records, reserved space, used space, index occupied space, unused space)

Exec sp_MSforeachtable "exec sp_spaceused'?"

Select * from # tableinfo

Number of order by records desc

Drop table # tableinfo

END

Second, use the following statement to check.

Exec sys_viewTableSpace

The above is all the contents of the article "how to check the data size of each table in a database by SQLServer". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.