Netezza Metadata Queries - Wirewoods - Welcome to your new Wikidot site - Wirewoods

Lifted from netezzaforum.com Query to get a list of views and thier definitions in a database: SELECT VIEWNAME,OWNER,CREATEDATE,DEFINITION FROM _V_VIEW WHERE OBJTYPE='VIEW'; Query to get a list of tables in a database: SELECT ...

wirewoods.wikidot.com