All Forums Database
venugopal2705 5 posts Joined 08/11
03 Nov 2011
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

dnoeth 4628 posts Joined 11/04
04 Nov 2011

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

Dieter

Dieter

You must sign in to leave a comment.