View details required for the underlying tablename

Database

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

2 REPLIES
Enthusiast

Re: View details required for the underlying tablename

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.

Teradata Employee

Re: View details required for the underlying tablename

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