Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 06 Nov 2004 @ 21:03:51 GMT


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


Subj:   Create table as in V2R5
 
From:   Anomy Anom

<-- Anonymously Posted: Saturday, November 06, 2004 14:05 -->

We have discovered that in V2R5 if we do a CREATE TABLE AS ( ... the new table gets created without some of the attributes from the source table. Example, if the source table had the NULL option set or the COMPRESS option set, the new table created does not.

Has anyone experienced this problem and know of any solution, other then doing a show table and then doing a create followed by insert / select.


Thanks



     
  <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: 27 Dec 2016