/SQL/Sql select all records from all tables where not empty

Sql select all records from all tables where not empty

SELECT r.table_name, r.row_count, r.[object_id]
FROM sys.tables t
INNER JOIN (
    SELECT OBJECT_NAME(s.[object_id]) table_name, SUM(s.row_count) row_count, s.[object_id]
    FROM sys.dm_db_partition_stats s
    WHERE s.index_id in (0,1)
    GROUP BY s.[object_id]
) r on t.[object_id] = r.[object_id]
WHERE r.row_count > 0
ORDER BY r.table_name;

Source: stackoverflow.com

Similar codes

3 votes220 views1 answer
Define REGEXP?
SQL
1 vote233 views1 answer
Tsql random number
SQL
8 votes241 views4 answers
Postgresql server restart
SQL
1 vote201 views7 answers
Filter
SQL
3 votes246 views2 answers
@sqlresultsetmapping
SQL
5 votes201 views1 answer
Oracle get nls settings
SQL
0 vote195 views1 answer
Delete * from where id = 1;
SQL
0 vote292 views1 answer
How to login to mysql in homestead
SQL
0 vote194 views1 answer
How to check xampp mysql password
SQL
0 vote259 views1 answer
Sql count matching group by
SQL