/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

36 votes301 views6 answers
Change column data type sql
SQL
12 votes178 views2 answers
Delete all nodes neo4j
SQL
3 votes195 views4 answers
Truncate syntax in sql
SQL
0 vote174 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
4 votes187 views4 answers
Oracle tablespace tables list
SQL
0 vote176 views1 answer
Sql clear table
SQL
6 votes206 views3 answers
Mysql create database utf8
SQL
0 vote208 views1 answer
How to combine rows in sql server procedure
SQL
8 votes184 views3 answers
Postgres connection string
SQL
0 vote176 views1 answer
Psql check if value in array
SQL