Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2005 @ 10:39:25 GMT

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

Here's one way, but it's probably not what you're looking for. You could use DBQL logging with Objects to get the underlying tables. Log DBQL with Objects on your userid, execute the macro, and look in the objects table for that query to get the databases, tables, columns, and indexes used by that macro. It will not give you views yet though. You could get views by logging to accesslogging and executing the macro.

Donna Becker
Senior Data Warehouse Consultant
Professional Services Americas
Teradata Certified Master
Teradata, a division of NCR

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