Netezza/PureData – How to pull a list of tables with row counts

Pulling a list of Netezza tables with row counts is fairly straight forward, once you figure it out.  Here is a sample of an easy way to do to.

SELECT TABLENAME, RELTUPLES

FROM _V_TABLE where objtype = ‘TABLE’ ORDER BY TABLENAME;

Leave a Reply