Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2005 @ 12:28:21 GMT


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


Subj:   Re: Views referring tables
 
From:   DycusR

Rachana,

The following will "probably" give you what you want - but I don't think it will guarantee getting all the views in question. If you have nested views, you would have to continue on with this logic, parsing the requesttext for the view name.

     Select    *
     From  dbc.tables
     Where requesttext like '%databasename.tablename%'
     and tablekind = 'v'  ;

Randy



     
  <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