Archives of the TeradataForum

Message Posted: Fri, 18 Nov 2011 @ 07:57:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

How to find the associated tables or view in teradata?

Let us assume, my table name is 'LOT' and view names are 'V1' and 'V2'

I am using my table 'LOT' in view 'V1' and i am using my view 'V1' in view 'V2'.

I just want to find the views associated with the table 'LOT'.If i use the following query,

     select * from dbc.tables

i will be getting only view 'V1'.i wont get the view name 'V2'.In teradata,where internal references are stored?

Can anyone please help me to find out?.I dont want to write the subquery to get the view 'V2'

This is the post I saw in 2008, but i was not able to find any good response...Do we have anything by now?

Thanks & Regards,

Vijay Kumar

	<Prev	Next>		<<First	<Prev	Next>	Last>>