SQL Server查询所有表的数据大小

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