Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 16:45:39 GMT


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


Subj:   Re: Drop column from view
 
From:   DWellman

Hi Dave,

Data types may make a difference if the view is doing calculations or using the underlying columns to create derived columns.

Similarly, if the view does the above sort of processing then the view may produce unexpected results depending on the change.

Bear in mind that (as Mike Dempsey said) a Teradata view is dynamic and therefore it is 'just a piece of sql' that gets runs (well, sort of). Think of the situations where a given piece of sql can produce 'unexpected results' because the underlying table(s) have changed. A view faces the same potential problem.


Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )



     
  <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