/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 vote207 views1 answer
Ceil upto 2 decimal place mysql
SQL
2 votes199 views1 answer
Coalesce sql
SQL
1 vote176 views1 answer
Vagrant mysql downgrade version
SQL
13 votes176 views2 answers
Sql online compiler
SQL
0 vote160 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
-1 vote161 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote191 views1 answer
Sql alter table order by
SQL
1 vote177 views1 answer
How to use db.execute
SQL
5 votes180 views1 answer
Find table from column name in sql
SQL
0 vote187 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL