list all database objects netezza
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)