/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 vote178 views1 answer
Mssql check if date is greater than today
SQL
1 vote164 views1 answer
Sql avg group by
SQL
1 vote195 views4 answers
Aggregate function in sql
SQL
1 vote195 views1 answer
Join to find results not in another table
SQL
0 vote220 views1 answer
Mysql subtract month from timestamp
SQL
6 votes244 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote173 views1 answer
How to add session data into mysql database from button
SQL
18 votes164 views3 answers
Mysql add column with default value
SQL
1 vote163 views3 answers
Getdate function in postgresql
SQL
0 vote215 views1 answer
Change date in pivot table to month in sql server
SQL