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

This article will explain in detail how to check the space used by each table in the database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

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

Exec sys_viewtablespace

In fact, in the final analysis, it is using sp_spaceused.

EXEC sp_spaceused Nintendbo.yourtablename`

GO

Batch empty some previously backed up tables

Select 'EXEC sp_spaceused Numeric animals won't listen to dbo.For other names, they won't' from sys.tables tbs where tbs.type='U' and name like'% _ 20%'.

GO

This is the end of the article on "how to check the space used by each table in the database". I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, please share it for more people to see.

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.