/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

0 vote240 views3 answers
How to run sql query
SQL
0 vote224 views1 answer
Nth max in my sql
SQL
2 votes239 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote175 views1 answer
Flask-sqlalchemy filter_by contains
SQL
1 vote222 views1 answer
Mysql monthname
SQL
4 votes223 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
1 vote224 views1 answer
Sql list all procedures
SQL
5 votes229 views1 answer
Mysql count newlines in field
SQL
0 vote221 views1 answer
Excute raw query
SQL
2 votes233 views1 answer
Columns Present in a table
SQL