Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 16 Aug 2007 @ 11:12:19 GMT


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


Subj:   Re: Dynamic View creation
 
From:   Barrow, Martin

Vinay,

Thanks for the stored procedure.

When creating the copy of the view, is there any way of determining the database and table that the view is using? i.e. View VW1 does a select * from DB1.TAB1, so I need to make my copy of the view use DB1.TAB1 also.


Regards,

Martin



     
  <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: 15 Jun 2023