/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 vote133 views1 answer
Call object contructor and call methods of object
SQL
0 vote124 views1 answer
How to search query in python3 sqlite3
SQL
1 vote96 views1 answer
Mysql show attributes of a table
SQL
1 vote135 views1 answer
Oracle case
SQL
1 vote131 views2 answers
Group_concat limit mysql
SQL
0 vote135 views1 answer
Mysql database hyphen
SQL
0 vote130 views1 answer
How to list function in psql
SQL
39 votes237 views5 answers
Sql drop column
SQL
3 votes141 views1 answer
Postgres add not null to existing column
SQL
0 vote120 views1 answer
How to execute stored output to csv files
SQL