I need exactly the same SQL to run against DBC.Tables. Trying to find all the base views containing a table and the views based off the base views.
Other than enabling MDS in Teradata, does anyone have sample recursive SQL for this?
I don't know if it were me ,I'd prolly run below sql three four ( with output being added to input everytime ) times or build recursive logic for the same.But usually you will have only 3-4 layers of view in which case you can fire query 2-3 times and get deisred results
WHERE REQUESTTEXT LIKE ANY
(SEL '%' || TABLENAME || '%'
WHERE TABLENAME IN