Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 11 Mar 2002 @ 20:26:01 GMT

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

Subj:   Re: Object dependancies
From:   Anomy Anom

<-- Anonymously Posted: Monday, March 11, 2002 14:32 -->

One method I have used is to search in the column dbc.tables.requesttext, since this column has view and macro definations.

Say if you are searching if Tbl1 is used in any view, you would use the sql:

select * from dbc.tables
where requesttext like '%tbl1%';

  <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