/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 vote320 views1 answer
Oracle show running job
SQL
2 votes336 views1 answer
Sqlite3 show columns name
SQL
3 votes326 views1 answer
Oracle user privileges
SQL
0 vote310 views1 answer
Show function mysql
SQL
2 votes334 views2 answers
Sql first character
SQL
0 vote365 views1 answer
Sql query wordpress export post
SQL
1 vote322 views1 answer
Sql server update column based on another table
SQL
-2 votes325 views1 answer
Modify column name in tsql
SQL
0 vote327 views1 answer
Mssql check if date is greater than today
SQL
0 vote329 views1 answer
Add multiple field in table sql
SQL