/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

1 vote258 views1 answer
Mysql tables max count
SQL
0 vote192 views1 answer
Psql select * from table
SQL
1 vote221 views1 answer
Lpad function in sql oracle
SQL
1 vote274 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
1 vote210 views1 answer
Select random sample sql
SQL
1 vote219 views2 answers
Oracle leftmost characters
SQL
0 vote214 views1 answer
Mysql grant grant option
SQL
0 vote230 views1 answer
Oracle db timestamp auto add
SQL
0 vote205 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote226 views1 answer
Sql query wordpress export post
SQL