Archives of the TeradataForum
Message Posted: Fri, 18 Nov 2011 @ 07:57:11 GMT
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.tableswhere RequestText like ('%LOT%');
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|