/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

2 votes334 views1 answer
Mysql time ago difference
SQL
0 vote351 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote337 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote378 views1 answer
Can you write relational algebra into sql queries
SQL
5 votes353 views6 answers
Sql foreign key
SQL
0 vote293 views1 answer
Check if has alpha characters sql
SQL
1 vote360 views3 answers
What is union in sql
SQL
20 votes378 views1 answer
Get all table name in sql through php
SQL
0 vote382 views1 answer
How to run mysql on terminal mac
SQL
0 vote332 views1 answer
Mysql date only no time
SQL