/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

0 vote217 views1 answer
Insert into select with group by
SQL
0 vote219 views2 answers
Select index table oracle
SQL
0 vote323 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote218 views1 answer
Match end of string regex sql
SQL
0 vote227 views1 answer
Php select data from mysql database without column name
SQL
0 vote211 views1 answer
SQL isnumeric DB2
SQL
8 votes241 views1 answer
Racle create auto increment column
SQL
4 votes223 views2 answers
Oracle unlock user
SQL
0 vote211 views1 answer
Sql server manager close connection
SQL
-2 votes243 views2 answers
Add auto_increment column to existing table mysql
SQL