Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Is there a system table or view in Netezza that shows the number of records for each table?
USED_BYTES/1073741824 as USED_GB,
RELTUPLES as "ROWS"
WHERE OBJCLASS = 4905 OR OBJCLASS = 4911
ORDER BY TABLENAME;
Please try this view for table
and for view this
Required, but never shown