04 Sep 2014
As far as I know you can find thru MDS( Metadata services).
This link may help also http://forums.teradata.com/forum/database/how-to-find-the-associated-tables-or-view-in-teradata
Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.
22 Oct 2014
Meta Data Services (MDS) can provide the following information for a Table:
Views that reference a table, Hash/Join Indeces defined on a table, Macros that reference a table, Stored Procedures that reference a table, Triggers that refcerence a table.
CHECK costraints in a table, Derived Period columns in a table, Triggers defined in a table.
You must sign in to leave a comment.
need your help,
does anyone have an SQL that lists the processes that are using a specific table. I would like to enter the table name
and the results would show me which process has/using that table..
thank you