/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 vote133 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
38 votes225 views6 answers
Ubuntu install mysql client
SQL
-2 votes151 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote161 views3 answers
Insert query in ci
SQL
2 votes196 views2 answers
Create table mysql integer NOT null
SQL
32 votes153 views6 answers
Insert into values select
SQL
19 votes148 views3 answers
Grant mysql
SQL
0 vote184 views1 answer
Opensuse start MySQL
SQL
0 vote137 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
3 votes139 views3 answers
Create a view postgres
SQL