Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Apr 2007 @ 17:41:48 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Finding out the table in Macros
From:   Anomy Anom

<-- Anonymously Posted: Friday, April 13, 2007 11:34 -->

You can use TERADATA ADMINISTRATOR to do this.

In TERADATA ADMINISTRATOR (or WINDDI in older version of TTU), select the table you want to check and right click then select reference function. This will return a list of macro of view which reference this table. You can scroll down to the database you are concern with and see if any macro or view reference this table from that database.

You can then go to SQL history (F12) in TERADATA ADMINISTRATOR to see the SQL you have just performed and use that same SQL to refine to your specification.

Hope this helps.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020