/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 votes145 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote141 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote142 views1 answer
Redudancy in SQL
SQL
0 vote127 views1 answer
Sql new line output
SQL
0 vote148 views1 answer
Window function to forward fill
SQL
4 votes141 views3 answers
Sqlite show columns
SQL
0 vote150 views1 answer
Group by max date
SQL
0 vote125 views1 answer
Mysql multiple count
SQL
0 vote640 views1 answer
Sql show table name in result
SQL
35 votes151 views5 answers
Sql alter column
SQL