Database list having table count is 0

Question

Hi team I have one table having name master_test in which there are 2 column database name and table name. In database name there are all database name of server and table name is rawdata in all database. Now I want list of database having rawdata table having no record (0 record). Please suggest simple way for the same Thanx & Regards, Krunal Pande

Answer 1

Please run bellow script .

you will get all tables information with number of rows

(you can modify this according to your requirement)

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
DROP TABLE #counts