/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 vote270 views1 answer
Implizite joins sql
SQL
0 vote296 views1 answer
Will graphql replace sql
SQL
0 vote352 views1 answer
Mysql get longest string in column
SQL
0 vote262 views1 answer
Sql count null as 0
SQL
0 vote267 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
1 vote284 views1 answer
Oracle select first result
SQL
0 vote294 views1 answer
Delete duplicate rows
SQL
0 vote271 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote296 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote278 views1 answer
Group by sql not ordering issues
SQL