SQL Server queries database tables using space information to implement scripts, SQL tables

SQL Server queries database tables using space information to implement scripts, SQL tables

Use the undisclosed Stored Procedure sp_MSforeachtable provided by Microsoft
 

Create table # temp (TableName NVARCHAR (128), RowsCnt VARCHAR (11), ReservedSpace VARCHAR (18), DataSpace VARCHAR (18), CombinedIndexSpace VARCHAR (18 ), unusedSpace VARCHAR (18) 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