All Forums Tools
v_gabrielli 33 posts Joined 04/10
04 Sep 2014
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

Vince
Tags:
Raja_KT 1246 posts Joined 07/09
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.

Triton 18 posts Joined 05/08
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.