/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

5 votes303 views1 answer
Mongodb vs
SQL
0 vote365 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
14 votes338 views1 answer
Excel is not a database
SQL
1 vote355 views1 answer
Postgresql escape single quote
SQL
0 vote333 views1 answer
How to check xampp mysql password
SQL
1 vote309 views1 answer
Reutrn string after character sql
SQL
0 vote336 views1 answer
Sql trying to delete database in use
SQL
0 vote347 views1 answer
Mariadb current date plus 1 day
SQL
-1 vote370 views3 answers
PS5
SQL
1 vote336 views1 answer
Simple project for database
SQL