SAP HANA: SQL statement to display which tables don't have any data

Viewed 33

Is there a SQL statement to identify which tables don't have any data.

1 Answers

Yes, you can query system view M_TABLES:

SELECT * 
FROM M_TABLES 
WHERE RECORD_COUNT = 0

Please be aware, that the content of M_TABLES is subject to the authorization concept.

Related