which Teradata process is using this table

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