/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

1 vote321 views1 answer
Create index concurrently postgres
SQL
0 vote338 views1 answer
Change filed order in mysql
SQL
0 vote331 views1 answer
Mysql export and import
SQL
1 vote340 views1 answer
Mysql drop key
SQL
0 vote316 views1 answer
Sql delete row from table where id
SQL
0 vote307 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote341 views1 answer
SQL SERVER xquery count child nodes
SQL
27 votes336 views5 answers
Add column in table
SQL
0 vote285 views1 answer
Java spring boot connect to sql server
SQL
0 vote368 views1 answer
Mysql relationships between tables
SQL