How to get column name wise table name list in particular database (Netezza). select distinct table_name from DB_NAME.._v_sys_columns where column_name in ('Reg_Number') order by 1;
How to get the database size in netezza server: SELECT o.dbname DatabaseName,((SUM(z.ALLOCATED_BYTES)/1024)/1024)/1024 AllocateSpaceGB, ((SUM(z.Used_BYTES)/1024)/1024)/1024 UsedSpaceGB, (AllocateSpaceGB-UsedSpaceGB) FreeSpaceGB FROM _V_SYS_OBJECT_DSLICE_INFO z JOIN _v_object_data o ON o.objid = z.tblid where DBNAME = 'DB_NAME' GROUP BY o.dbname order by o.dbname;