/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 vote192 views2 answers
Connect to mysql server mac terminal
SQL
0 vote236 views1 answer
SQL Cut part string
SQL
0 vote198 views1 answer
OFFSET consulta mysql
SQL
2 votes288 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote244 views1 answer
Mysql default uuid
SQL
4 votes236 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote230 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote197 views2 answers
Temp Space
SQL
0 vote178 views2 answers
Mysql regexp match word
SQL
18 votes192 views2 answers
Sql inner join
SQL