Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Nov 2002 @ 13:17:02 GMT


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


Subj:   Implications of 2 different DDLs of a same view??
 
From:   Rohit Revo

What is the difference between the two?

If we have the Data Definition of a view in the following 2 ways, what are the implications. Obviously, the first one does the job as intended.

REPLACE VIEW XXXX as
LOCKING TABLE ABC FOR ACCESS
Sel a,b,c from xyz;

LOCKING TABLE ABC FOR ACCESS
REPLACE VIEW XXXX as
Sel a,b,c from xyz

Thanks



     
  <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