Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Jan 2007 @ 18:41:19 GMT

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

Subj:   Re: Re-Creation of a View after drop and Recreating of the Table
From:   Vinay Bagare

View has to be replaced again if there were changes to the base table.

If there are new columns added to a base table, and the view is SELECT * from the base tables, then the new column won't appear automatically.


Vinay Bagare

  <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: 28 Jun 2020