Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Jan 2007 @ 14:01:43 GMT


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


Subj:   Re: Invalid views
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, January 16, 2007 08:39 -->

Since Teradata uses "late binding" based on name and not internal ID like some other databases, the DBMS doesn't know or care if the view is "valid" until it tries to parse and resolve a query. So you have to do something such as

     EXPLAIN SELECT * FROM MYVIEW;


     
  <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