Skip to content

Find list of views built on a specific table – Netezza

You can run below query in your database to find out all the views which are built on a specific table in a specific database.

select VIEWNAME from _v_view where DEFINITION like ‘%Table Name%’ and DEFINITION like ‘%Database Name%’;

Replace Table Name with actual table name and Database Name with actual database in which the table resides.