All Forums Database
meena.krishnan 1 post Joined 02/13
22 Jan 2016
View details required for the underlying tablename

Hi ,
I would like to is there a way we can get all the view names which are created on top of a  specified tablename, by giving tablename as input.
 
Thanks,
Meena

manib0907 61 posts Joined 04/15
23 Jan 2016

SELECT * FROM DBC.TABLES WHERE REQUESTTEXT LIKE '%TBL_NM%' AND TABLEKIND='V'; Can you try this?
But I think the requesttext value chages if the table is altered. 
P.S: I have not tried this, think this should work.

Cheers,
Mani

Adeel Chaudhry 773 posts Joined 04/08
26 Jan 2016

Alternatively, you can use 'References' in Teradata Admin.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.