Archives of the TeradataForum
Message Posted: Mon, 11 Mar 2002 @ 22:39:25 GMT
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.
Thomas F. Stanek
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|