/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 vote293 views1 answer
Add alternate add column sql
SQL
1 vote289 views1 answer
Set statiscis on in sql server
SQL
0 vote289 views1 answer
Django mysqlclient connection string
SQL
16 votes320 views6 answers
Install sqlite3 python
SQL
1 vote331 views1 answer
Mysql count all table rows
SQL
20 votes313 views6 answers
Creating a table in sql
SQL
0 vote304 views1 answer
Show create table in postgresql
SQL
5 votes328 views2 answers
Postgresql add not null constraint
SQL
3 votes293 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote310 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL