Is there a SQL statement to identify which tables don't have any data.
Is there a SQL statement to identify which tables don't have any data.
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.