34,590
社区成员
发帖
与我相关
我的任务
分享
create table #(name varchar(20),rows int,reserved varchar(100),data varchar(100),index_size varchar(100),unused varchar(100))
EXEC sp_MSforeachtable @command1="insert # exec sp_spaceused '?'"
select * from # order by 1*replace(data,' kb','') desc
drop table #
create table #aa(name varchar(100),rows int,reserved varchar(200),data varchar(200),index_size varchar(200),unused varchar(200))
declare @table varchar(100)
declare cur cursor local
for select Name
from sysobjects where xtype='u'
open cur
fetch next from cur into @table
while @@FETCH_STATUS = 0
begin
insert into #aa exec sp_spaceused @table
fetch next from cur into @table
end
deallocate cur
select * from #aa order by [name]
EXEC sp_MSforeachtable @command1="sp_spaceused '?'"
declare @sql nvarchar(max)
set @sql=''
select @sql=@sql + ' exec sp_spaceused '+ [name]+'; ' from sysobjects where xtype=N'U'
exec(@sql)