Table references from view?

Tell us what features you'll want
Post Reply
mritsema
Posts: 1
Joined: Thu Jun 14, 2018 10:53 pm

Table references from view?

Post by mritsema » Thu Jun 14, 2018 10:56 pm

Is there a way to show relationships like what tables are being referenced when viewing a view? I'm actually using vertica in a schema with hundreds of views. It would be useful to see what tables are referenced by the view or see what views are referencing a given table. Since it's Vertica, showing projections would obviously be just as useful.

Derrils
Posts: 1
Joined: Mon Sep 24, 2018 2:53 pm
Contact:

Re: Table references from view?

Post by Derrils » Mon Sep 24, 2018 2:54 pm

Is there any way to know if a particular table is being referenced by any Views or not.I used the below code which gives only SP's and function names:

Post Reply