list all database objects netezza code example

Example: 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)