patternMinor
Netezza: What schema contains all the system tables / views?
Viewed 0 times
tablesthenetezzawhatallsystemviewscontainsschema
Problem
Is there a schema I can look in or a query that I can run to see all the Netezza system or metadata tables?
I know about
I know there are many others and I would like the definitive list.
Documentation on each would be nice too, but I will settle for just a list.
I looked at How list of netezza system tables/views? but I am looking for a list of system tables. The author of that question is looking to pull specific metadata about the tables on his system.
I know about
_v_table, _v_view, _v_relation_column, and _v_groupusers.I know there are many others and I would like the definitive list.
Documentation on each would be nice too, but I will settle for just a list.
I looked at How list of netezza system tables/views? but I am looking for a list of system tables. The author of that question is looking to pull specific metadata about the tables on his system.
Solution
I don't know of a way to access such a list via a query but IBM provide a list of user views and system views in their Knowledge Centre. I assume those pages are public because their website tells me I'm not currently logged in (but it's not the most user-friendly of sites in terms of authentication so I may be wrong).
As CraigBoyd pointed out in a comment,
As CraigBoyd pointed out in a comment,
SELECT FROM _V_SYS_VIEW; will give you the list of system views. SELECT FROM _V_VIEW; will also list some of the system views plus any user-defined views. I can't tell why some views are included in _V_SYS_VIEW but not in _V_VIEW.Context
StackExchange Database Administrators Q#109149, answer score: 2
Revisions (0)
No revisions yet.