SQL statistics the number of records in all tables in a database _mssql

Copy Code code as follows:

CREATE TABLE #tmptb (tbname sysname,tbrows int
, tbreserved varchar (+), Tbdata varchar (10)
, Tbindexsize varchar (a), tbunused varchar (10))
INSERT into #tmptb exec sp_msforeachtable ' exec sp_spaceused '? '
SELECT * FROM #tmptb--Lists all tables
SELECT tbrows, tbname from #tmptb WHERE tbrows=0-List of tables with record data of 0
ORDER BY Tbname
DROP TABLE #tmptb

which
Tbname Table Name
Number of Tbrows Records
tbreserved Reserved Space
Tbdata Use space
Tbindexsize Index Use space
Tbunused Unused Space