/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

2 votes197 views1 answer
Update trigger
SQL
0 vote215 views1 answer
Sql query to return field name of a table
SQL
0 vote323 views2 answers
Mysql insert rows to another database
SQL
4 votes325 views1 answer
Oracle table statistics
SQL
7 votes180 views3 answers
Add primary key to database sql
SQL
0 vote230 views1 answer
Postgresql concat string with separator
SQL
0 vote204 views1 answer
List mysql tables and views
SQL
3 votes247 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote199 views2 answers
Start mysql server using docker
SQL
1 vote198 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL