/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 vote229 views1 answer
Primary key with prefix sql
SQL
0 vote205 views4 answers
Mysql desactivar trigger
SQL
0 vote189 views1 answer
What is the use of index in mysql table
SQL
8 votes291 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote203 views1 answer
Mysql wait_timeout
SQL
1 vote227 views1 answer
Sql select row with max date
SQL
7 votes204 views3 answers
SQL create a new table
SQL
0 vote193 views1 answer
First Step in installing SQL workbench
SQL
0 vote232 views1 answer
How to define a non primary composite key in sql
SQL
0 vote203 views1 answer
Doesn't have default value mysql
SQL