How to get a list of Tables and Columns a set of Stored Procedures use?

Database

How to get a list of Tables and Columns a set of Stored Procedures use?

Hi,

 

I am trying to find if there is an automated way of finding  the list of tables and columns a set of stored procedures interact on my teradata warehouse. Since I have a bunch of stored procedures that I use, I donot want to manually scan through each stored procedure to get the list of tables and columns. 

2 REPLIES
Junior Contributor

Re: How to get a list of Tables and Columns a set of Stored Procedures use?

The same question was asked a few days ago, you need access to DBQL, see https://community.teradata.com/t5/Database/how-do-i-find-references-of-tables-in-any-procedure-in-te...

Re: How to get a list of Tables and Columns a set of Stored Procedures use?

Dneoth - Thanks for pointing out the right thread.