/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

8 votes324 views1 answer
Sql limit results returned
SQL
1 vote323 views2 answers
Sql queries practice
SQL
0 vote339 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote320 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
13 votes262 views2 answers
Oracle all source
SQL
1 vote308 views4 answers
Postgres extract date from timestamp
SQL
1 vote302 views1 answer
Check message id sql server
SQL
0 vote293 views1 answer
Sql comparison operators
SQL
0 vote316 views1 answer
Sql show all users
SQL
2 votes317 views1 answer
How to delete view in sql
SQL