I want to find the dependent table of views in Netezza. Is there a table that provides the details?
How to find view dependencies in Netezza
ibm-netezza-administratornetezza
Related Question
- Windows – Installing Netezza 6.0.8 ODBC driver on Windows Server 2008
- Sql-server – Netezza Equivalent to T-SQL ROWVERSION or PL/SQL ORA_ROWSCN
- How to obtain row counts for all tables in Netezza
- Netezza LIKE Operator Issue with Backslashes
- Last accessed timestamp of a Netezza table
- Netezza: What schema contains all the system tables / views
- Netezza to Azure Synapse – Migrating Stored Procedures
Best Answer
This is actually pretty hard to do on Netezza because there are no system tables keeping track of table dependencies in views. Therefore you need to parse every view to get the referenced objects. There is a Unix support script on the server which does exactly this and will dump the results in a table. You might need to install the support package. Replace the database name with your database and run this command.
When the script is finished (be patient), the results are located in table SYSTEM.NZ_VIEW_REFERENCES