which Teradata process is using this table

Tools & Utilities
Enthusiast

which Teradata process is using this table

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

Tags (1)
2 REPLIES
Enthusiast

Re: which Teradata process is using this 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

Teradata Employee

Re: which Teradata process is using this table

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.