/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 vote188 views1 answer
Add multiple row table pl sql
SQL
1 vote195 views2 answers
Mysql does sentance contain word
SQL
0 vote202 views2 answers
Select index table oracle
SQL
0 vote199 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote182 views1 answer
Hour and minute between two datatime sql
SQL
4 votes173 views4 answers
Start mysql
SQL
0 vote198 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote179 views1 answer
Postgresql how to show table names
SQL
5 votes261 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote176 views1 answer
Get clob size oracle
SQL