Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 16:19:34 GMT


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


Subj:   Re: Drop column from view
 
From:   Curley, David

Remember also that replace view keeps existing grants in place, so you don't have to restore them as you would with drop + create.

Kind of related to this, I just noticed something interesting in the DDL SQL reference manual:

"If tables referenced by a view are modified to add or remove columns, or change data types of existing columns, then attempts to access the view can result in error messages or unexpected results. This is true whether the view references table columns by name or by SELECT *."


I'm surprised that a) data type changes would matter to views and b) the database's response could be "unexpected results" rather than throwing an error.


Dave



     
  <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