/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

5 votes195 views1 answer
Oracle asynchronous query
SQL
0 vote194 views1 answer
How to count with except in psql
SQL
15 votes215 views5 answers
If null mysql
SQL
1 vote195 views1 answer
How to print longest name in sql
SQL
0 vote196 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote211 views1 answer
Restore backup mysql .gz
SQL
2 votes196 views1 answer
Mariadb select multiple rows into one column
SQL
14 votes227 views2 answers
Oracle limit rows
SQL
1 vote207 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
34 votes243 views6 answers
Alter table add foreign key mysql
SQL