/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 vote291 views1 answer
Sql first day quarter
SQL
0 vote276 views1 answer
Sqlalchemy query join many to many
SQL
0 vote258 views1 answer
Get created time of database psql 8
SQL
0 vote269 views1 answer
Datagrip go to line
SQL
3 votes272 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote273 views1 answer
Using distinct and count together in sql
SQL
0 vote299 views1 answer
Create user faunadb
SQL
10 votes263 views2 answers
Sql merge statement
SQL
0 vote257 views1 answer
Mysql begin statement
SQL
3 votes276 views2 answers
Sql select data from last week
SQL