Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Object dependancies
From:   Thomas F. Stanek


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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020