/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 vote233 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote252 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
3 votes250 views2 answers
Find string in stored procedure sql server
SQL
1 vote267 views1 answer
Oracle columns table
SQL
11 votes255 views6 answers
Distinct sql
SQL
9 votes236 views5 answers
Sql limit
SQL
1 vote262 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
7 votes259 views1 answer
Oracle pagination query rownum
SQL
0 vote238 views1 answer
Connexion mysql
SQL
1 vote229 views1 answer
Truncate left characters mysql
SQL