Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 13:27:43 GMT


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


Subj:   Re: Drop column from view
 
From:   Dempsey, Mike

Based on the responses I have seen there appears to be some confusion out there when it comes to views.

On some other database systems views are 'compiled'. On Teradata they are dynamic - there is no compile. (The definition is simply stored in the dictionary - after parsing and verifying that the references are valid.)

To drop a column, or make any other change, you simply use 'Replace View ...' and that new version will automatically be used the next time someone references the view.


Mike Dempsey
Teradata Client Tools



     
  <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