/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 votes262 views3 answers
Current month mysql query
SQL
2 votes274 views1 answer
Postgresql create schema in specific database
SQL
3 votes269 views1 answer
Define REGEXP?
SQL
0 vote257 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote289 views1 answer
Dropping a constraint in ms sql
SQL
0 vote280 views1 answer
Watch mysql command line
SQL
0 vote269 views1 answer
Copy value from one column to another postgres
SQL
1 vote244 views1 answer
SQLSTATE[HY000] [2002]
SQL
1 vote296 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote268 views1 answer
Mysql beautifier terminla
SQL