/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 vote318 views1 answer
Mysql curdate between two dates
SQL
8 votes302 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote324 views1 answer
Local pg_sql to heroku pg_sql
SQL
1 vote270 views1 answer
Autocommit mysql
SQL
1 vote303 views3 answers
Nth highest salary
SQL
51 votes401 views6 answers
Change column name sql
SQL
0 vote304 views1 answer
Database xml sql
SQL
1 vote310 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote306 views2 answers
Find nth highest salary of an employee
SQL
4 votes304 views4 answers
Pl sql output
SQL