How to obtain row counts for all tables in Netezza?

Question

Is there a system table or view in Netezza that shows the number of records for each table?

Answer 1

How about:

SELECT TABLENAME,
       OBJTYPE,
       OWNER,
       CREATEDATE,
       USED_BYTES,
       USED_BYTES/1073741824 as USED_GB, 
       RELTUPLES as "ROWS"
 FROM _V_TABLE_ONLY_STORAGE_STAT
 WHERE OBJCLASS = 4905 OR OBJCLASS = 4911
 ORDER BY TABLENAME;

Answer 2

Please try this view for table "_v_table". and for view this "_v_view"

good luck