/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 vote183 views1 answer
How to see logical reads in sql server
SQL
0 vote156 views1 answer
Ms sql unique
SQL
0 vote178 views1 answer
Less than and between in sql query
SQL
0 vote170 views1 answer
Import mysql'
SQL
0 vote189 views2 answers
Replace null with 0 in sql
SQL
0 vote177 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote170 views1 answer
Bigquery declare
SQL
0 vote191 views1 answer
Zerar auto increment mysql
SQL
0 vote193 views1 answer
How to find columns with null values in sql
SQL
1 vote175 views2 answers
Select only columns that are not empty oracle sql
SQL