Is there a SQL statement that will let me list out all the objects ( tables views SP's macros ) that are involved in a Teradata SQL Query- much like show select * from WITHOUT expanding their DDL's This would be the same as equivalent of what Visual Explain did.
Asked
Active
Viewed 105 times
1
-
1`SHOW SELECT` is the best you can get. – dnoeth Oct 01 '15 at 06:13
-
Beyond @dnoeth's advice, if you have access to DBQL and object logging is enabled you can get more detail in DBQL. But that may be overkill for the average developer or ad hoc user. – Rob Paller Oct 01 '15 at 15:22
-
Ok thank you Learned ppl – user1874594 Oct 01 '15 at 17:00