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..
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
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.