CREATE TABLE tb_SpaceInfoTable
(
ID int identity(1,1),
name sysname,
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18)
)
GO
EXEC SP_MSFOREACHTABLE
@COMMAND1 = 'INSERT INTO tb_SpaceInfoTable(name,
rows,
reserved,
data,
index_size,
unused)
EXEC SP_SPACEUSED ''?'''
GO
SELECT * FROM tb_SpaceInfoTable
GO
SQLServer如何查看数据库中表占用的磁盘空间
最新推荐文章于 2024-05-29 14:20:04 发布