Check out example codes for "list all database objects netezza". It will help you in understanding the concepts better.

Code Example 1

select database::nvarchar(64) as database, OBJTYPE, count(OBJNAME) as Tables_count
from (select *
from _V_OBJ_RELATION_XDB
where database <> 'SYSTEM') a
group by database,OBJTYPE;

 DATABASE | OBJTYPE | TABLES_COUNT
----------+----------------+--------------
 TEST | TABLE | 1
 TRAINING | EXTERNAL TABLE | 1
 TRAINING | PROCEDURE | 2
 TRAINING | SEQUENCE | 1
 TRAINING | TABLE | 21
 TRAINING | VIEW | 3
(6 rows)

Learn ReactJs, React Native from akashmittal.com