/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 vote246 views1 answer
Login phpmyadmin without password
SQL
0 vote273 views1 answer
Oracle drop type
SQL
0 vote256 views1 answer
Product of a column in mysql
SQL
0 vote442 views1 answer
Get first match in each group mysql query
SQL
0 vote245 views1 answer
Mysql function variable
SQL
1 vote276 views1 answer
Round one decimal place mysql
SQL
9 votes262 views1 answer
Mysql check date range
SQL
1 vote248 views1 answer
Sql server find tables referenced foreign key
SQL
2 votes262 views1 answer
Mysql create user with mysql_native_password
SQL
3 votes251 views2 answers
Pl sql escape '
SQL