MSSQL中查所有表数据大小

DECLARE @tablespaceinfo TABLE (   
    nameinfo varchar(50),   
    rowsinfo int,   
    reserved varchar(20),   
    datainfo varchar(20),   
    index_size varchar(20),   
    unused varchar(20)   
)  
  
DECLARE @tablename varchar(255);   
  
DECLARE Info_cursor CURSOR FOR  
    SELECT [name] FROM sys.tables WHERE type='U';   
  
OPEN Info_cursor   
FETCH NEXT FROM Info_cursor INTO @tablename   
  
WHILE @@FETCH_STATUS = 0   
BEGIN  
    insert into @tablespaceinfo exec sp_spaceused @tablename   
    FETCH NEXT FROM Info_cursor   
    INTO @tablename   
END  
  
CLOSE Info_cursor   
DEALLOCATE Info_cursor   
  
SELECT *, convert(varchar, ((
Cast(Replace(reserved,'KB','') as INT) + 
Cast(Replace(datainfo,'KB','') as INT) +
Cast(Replace(index_size,'KB','') as INT) +
Cast(Replace(unused,'KB','') as INT)
) / (1024 * 1024)
)) + ' g'
as totaldata
 FROM @tablespaceinfo ORDER BY Cast(Replace(reserved,'KB','') as INT) DESC  

百度找的。出处不明。