/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

4 votes156 views2 answers
Oracle default date format
SQL
20 votes169 views4 answers
Sql count if
SQL
1 vote171 views2 answers
Sql now - 1 day
SQL
0 vote199 views1 answer
Drop a view in sqlite
SQL
0 vote158 views1 answer
Frename oracle
SQL
15 votes140 views2 answers
Install mysql 8 ubuntu 18.04
SQL
8 votes167 views1 answer
Check mysql version phpmyadmin
SQL
17 votes145 views4 answers
Sort by mysql
SQL
1 vote148 views2 answers
ImportError: No module named mysql.connector
SQL
2 votes145 views1 answer
Oracle calculated column
SQL