Archives of the TeradataForum

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

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

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