Stored procedure and its dependency using Data Dictionary tables

Database
Enthusiast

Stored procedure and its dependency using Data Dictionary tables

Hi All

I would like to find out the dependency between Stored procedures and the associated tables using data dictionary tables. I have tried my best to find out but went in vain.

Please suggest me a way to find out using teradata only.

I dont have admin access to see what is happening in the back end. If any admin guy is there means please provide the information related to SP's and the information tables.

Regards,

VG

1 REPLY
Junior Contributor

Re: Stored procedure and its dependency using Data Dictionary tables

The system tables don't have that information, the only way to get it is using Teradata's Meta Data Services add-on.

Dieter