/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 vote104 views2 answers
Sql having multiple conditions
SQL
5 votes265 views2 answers
How to ascending order in sql
SQL
0 vote105 views1 answer
Difference between min and max date sql
SQL
1 vote138 views1 answer
Oracle transaction rollback not working
SQL
0 vote111 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote104 views1 answer
How to read the potentail error messages in ssis package
SQL
4 votes95 views3 answers
Order by value mysql
SQL
1 vote102 views2 answers
Create a unqie constraint mysql
SQL
0 vote128 views2 answers
Plpgsql
SQL
0 vote53 views1 answer
Update row in sqlite python
SQL