IF OBJECT_ID('TEMPDB..#tmp')IS NOT NULL DROP TABLE #tmp
create table #tmp(name nvarchar(100), rows int, reserved nvarchar(100), data nvarchar(100), index_size nvarchar(100), unused nvarchar(100));
EXEC sp_MSforeachtable 'insert into #tmp exec sp_spaceused "?"'
select * from #tmp order by len(data) desc,data desc
赠送一个删除整表的脚本
TRUNCATE TABLE tablename