I wish to know if there is a script that i can create, in any possible platform , that will help me identify all the database objects( procedures, tables, macros, etc) that are making use of a particular object(i.e, table/view) .
For example if suppose I have a database of containing 100 procedures, 150 tables etc and I want to identify every object that has used employee table in its definition.
Please help with the same.
Thanks in advance
Without proper metadata management this is almost impossible.
for relating Tables, Views and Macros, but for Stored Procedure you must export SHOW statements and
I am new to teradata, thanks a lot for the reference link. Can you please give a little detail , as in, what do you mean when you say proper data management.
The data that is available to me is quite well organized
main database >
and so on....