查看 SQL Server DB 表的大小

CREATE TABLE #tmp_ (
name       VARCHAR(100) ,
rows       INT ,
reserved   VARCHAR(100) ,
data       VARCHAR(100) ,
index_size VARCHAR(100) ,
unused     VARCHAR(100) 
);

INSERT INTO #tmp_ ( name , rows , reserved , data , index_size , unused) 
EXEC sys.sp_MSforeachtable 'exec sp_spaceused [?]';

UPDATE #tmp_        
SET reserved = replace(reserved , ' KB' , '') , data = replace(data , ' KB' , '') , index_size = replace(index_size , ' KB' , '') , unused = replace(unused , ' KB' , '');
 
SELECT name , ROUND( ( ( CONVERT(FLOAT , data) + CONVERT(FLOAT , index_size) ) / 1024.0 ) / 1024.0 , 2) AS SizeInGb INTO #tmp_final FROM #tmp_;

SELECT * FROM #tmp_final ORDER BY SizeInGb DESC;