/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 votes310 views5 answers
Get last query in codeigniter 4
SQL
0 vote310 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote324 views1 answer
How to change mysql root password in windows 10
SQL
12 votes315 views1 answer
Run mysql instance in docker
SQL
5 votes279 views2 answers
Sql server check port number
SQL
0 vote276 views1 answer
Add column not null with default value postgres
SQL
0 vote298 views1 answer
Dbms_output sql developer
SQL
11 votes313 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote283 views1 answer
How to connect postgresql database with java
SQL
5 votes246 views1 answer
Alter table default value mysql
SQL