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

IBM Netezza / IBM PureData for Analytics

IBM Netezza / IBM PureData for Analytics

 

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;