/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 vote166 views3 answers
How to restart mysql in linux
SQL
1 vote142 views1 answer
Importance of comment in mysql
SQL
19 votes255 views5 answers
Mysql between date range
SQL
0 vote152 views2 answers
Sql drop view if exists
SQL
12 votes149 views4 answers
Install mysql ubuntu 18.04
SQL
1 vote166 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote175 views1 answer
Get only one row in mysql
SQL
1 vote175 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote149 views3 answers
Postgresql grant alter table to user
SQL
2 votes159 views2 answers
Run mysql command from bash
SQL