Archives of the TeradataForum

Message Posted: Mon, 11 Mar 2002 @ 22:39:25 GMT

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

Ruth,

Looking through the dictionary as David Wellman suggested will likely work. The only caution is if you use macros to create your objects. In that case, what will be in the requesttext field is the exec macro statement. If you don't use macros to create your objects you'll probably be fine.

Another approach is to do a SHOW "object" on all your objects, write it to a file and then grep through it looking for the table your are referencing. Not a great approach, but it should find all your references. Maybe you could do that after using Dave's approach to identify the objects to drop, as a safety check.

Regards,

Thomas F. Stanek
TFS Consulting
www.tfsconsulting.com

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