Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2005 @ 22:14:00 GMT

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

You can look at dbc.tvm.CreateText and search for anything of the form "<dbname>"."<tblname>"

Note that this will give you only the directly referenced objects, not tables that are referenced through views, or objects that are referenced thru macros. You would need to make it recursive in order to find those.

Mike Dempsey
Teradata Client Tools

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