SQL query table size rows and usage space

DECLARE @D datetimeset @d=getdate () SET NOCOUNT on EXEC sp_msforeachtable @PRECOMMAND =n ' CREATE table # # (ID INT IDENTITY, table name SYSNAME, number of fields int, record number int, reserved space NVARCHAR (20), use space varchar (20), Index uses space varchar (20), unused space varchar () ', @COMMAND1 =n ' INSERT # # (table name, number of records, reserved space, use space, index use space, unused space) EXEC sp_spaceused "?        " UPDATE # # Number of SET fields = (SELECT COUNT (*) from syscolumns WHERE id=object_id ('? ')) WHERE id=scope_identity () ', @POSTCOMMAND =n ' select * from # # ORDER by record number DESC DROP TABLE # # ' SET NOCOUNT OFF SELECT [statement Run takes time (ms)]=datediff (Ms,@d,getdate ())

SQL query table size rows and usage space