SQL Server query database tables use spatial information to implement scripts _mssql

Using the non-public stored procedures provided by Microsoft Sp_msforeachtable

CREATE TABLE #temp
(
 tablename NVARCHAR (128),
  rowscnt VARCHAR (one),
 reservedspace VARCHAR (
 a), DataSpace VARCHAR (km),
 Combinedindexspace VARCHAR (a),
 unusedspace VARCHAR ()
 
 EXEC sp_ Msforeachtable ' INSERT into #temp (tablename, rowscnt, Reservedspace,dataspace, Combinedindexspace, unusedspace) EXEC sp _spaceused '? ', FALSE '
 
SELECT tablename, Rowscnt,reservedspace, DataSpace, Combinedindexspace, Unusedspace From
 #temp
 ORDER BY TableName
 
DROP TABLE #temp