/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 vote361 views2 answers
Postgres copy table from one schema to another
SQL
0 vote370 views1 answer
One table with another
SQL
4 votes338 views2 answers
Mysql show indexes on table
SQL
0 vote356 views1 answer
Subquery aggregation
SQL
0 vote342 views1 answer
Sqlite3 get data from table c
SQL
0 vote358 views1 answer
Sql case when exists in another table
SQL
1 vote368 views1 answer
Postgresql append array
SQL
0 vote361 views1 answer
Mysql in clausule string array
SQL
1 vote364 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote363 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL