Data size of all tables in 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 parameter 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 limit 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

Baidu. The source is unknown.