Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 20 Dec 2003 @ 05:32:45 GMT


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


Subj:   Suggestions for checking whether table exists or not
 
From:   Dheeraj Garg

Hi,

I am very sure that lot of times we have a requirement in which we have to create the intermediate temp table before loading it and after execution of the complete job we drop it. My question is how efficiently we can check whether table exists or not. Actually if table exists then i will drop it and recreate it otherwise directly create it. I have to do through BTEQ. Your suggestions are valuable to me.


With Regards

Dheeraj GARg



     
  <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: 27 Dec 2016