/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 vote161 views1 answer
Site:av.ru "files"
SQL
1 vote512 views1 answer
How to lock table in mysql
SQL
0 vote109 views1 answer
Postgres enumerated type
SQL
1 vote107 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
17 votes121 views3 answers
How to change a collumn name in sql
SQL
0 vote103 views1 answer
Sql server select furst day of current year
SQL
4 votes109 views1 answer
Sql delete multiple conditions
SQL
0 vote123 views1 answer
Fetching data from mysqldb
SQL
3 votes105 views3 answers
Into in sql
SQL
0 vote93 views1 answer
Difference between cross apply and inner join
SQL