34,576
社区成员
发帖
与我相关
我的任务
分享
create table #t(name nvarchar(100),rows nvarchar(100),reserved nvarchar(100),data nvarchar(100),index_size nvarchar(100),unused nvarchar(100))
go
insert into #t EXEC sp_MSforeachtable "EXECUTE sp_spaceused '?'"
select * from #t
/*
name rows reserved data index_size unused
---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------
titleauthor 25 56 KB 8 KB 48 KB 0 KB
stores 6 24 KB 8 KB 16 KB 0 KB
sales 21 40 KB 8 KB 32 KB 0 KB
roysched 86 32 KB 8 KB 24 KB 0 KB
discounts 3 16 KB 8 KB 8 KB 0 KB
jobs 14 24 KB 8 KB 16 KB 0 KB
pub_info 8 160 KB 120 KB 16 KB 24 KB
employee 43 40 KB 8 KB 32 KB 0 KB
authors 23 40 KB 8 KB 32 KB 0 KB
publishers 8 24 KB 8 KB 16 KB 0 KB
titles 18 40 KB 8 KB 32 KB 0 KB
(11 行受影响)
*/
go
drop table #t
eXEC sp_MSforeachtable "EXECUTE sp_spaceused '?'"