/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 vote116 views1 answer
Show create table in postgresql
SQL
0 vote121 views1 answer
Kotlin sqlite delete row
SQL
0 vote121 views1 answer
Android sqlite get rows count
SQL
3 votes129 views1 answer
V$session not found in oracle
SQL
0 vote105 views1 answer
Sql select all tables from database change url
SQL
0 vote117 views1 answer
Sql remove non numeric characters
SQL
0 vote128 views2 answers
Sql query print strings and int
SQL
1 vote87 views1 answer
Postgres grant read only access to database
SQL
-1 vote85 views1 answer
Mysql if example
SQL
1 vote117 views1 answer
Oracle check table lock
SQL