6

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 _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.

Community
  • 1
CraigBoyd
  • 61
  • 1
  • 1
  • 2

4 Answers4

2

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, 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.

Paul White
  • 94,921
  • 30
  • 437
  • 687
Carl
  • 171
  • 4
0
SELECT * FROM _V_VIEW WHERE VIEWNAME LIKE '_V%' ORDER BY VIEWNAME:

Gives you all the system view names. All the view names are self descriptive.

Marco
  • 3,720
  • 5
  • 25
  • 31
Nivin Govindan
  • 1
-2

use the _XDB tables. some work. some dont. pity because I cant get at tables but not distribution keys, which would be useful given multiple databases with the same patterns across many

EZ Powell
  • 1
-4

ADMIN schema contains the metadata views.

user2600421
  • 1
  • 1