/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 vote99 views1 answer
Sql how to duplicate a table
SQL
0 vote103 views1 answer
Grant access on table in oracle
SQL
1 vote102 views1 answer
Oracle user last connection date
SQL
2 votes97 views1 answer
Check isolation level in mysql
SQL
2 votes88 views2 answers
How to create an empty table from an existing table
SQL
15 votes115 views6 answers
Drop foreign key mysql
SQL
0 vote114 views1 answer
Mysql value ends with
SQL
1 vote104 views2 answers
Pad zero sql server
SQL
1 vote145 views1 answer
Psql client write to bash variable
SQL
21 votes108 views4 answers
Oracle add column
SQL