ALL TABLES Row size and count

DECLARE @temp  as TABLE (

      NAME VARCHAR(100) ,

      ROWS INT,

      RESERVED VARCHAR(100),

      DATA VARCHAR(100),

      INDEX_SIZE VARCHAR(100),

      UNUSED VARCHAR(100))

 

INSERT INTO @temp EXEC sp_msforEachTable " exec sp_spaceused '?' "

 

SELECT * FROM @temp