/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 vote216 views1 answer
Delete dublicate rows sql
SQL
11 votes159 views2 answers
Sql rank
SQL
37 votes283 views3 answers
Sql check duplicate value in column
SQL
0 vote184 views2 answers
Pop sql insert value into
SQL
1 vote168 views1 answer
Import sql file mysql commadn line
SQL
0 vote136 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote155 views1 answer
Declaring variables in pl sql
SQL
-1 vote167 views1 answer
Mysql coalesce
SQL
1 vote177 views1 answer
Influxdb export to csv
SQL
6 votes152 views1 answer
Phpmyadmin reset root password
SQL