select count from all tables in database

To get count of records in all database please use following query:

 
 
--DROP table  #counts 
CREATE TABLE #counts 
( 
    table_name varchar(255), 
    row_count int 
) 
 
EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?' 
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC