Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Jan 2006 @ 14:04:57 GMT


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


Subj:   ALTER table to add compression
 
From:   nazy_gholizadeh

Can an existing column in a table be changed to have compression? other than either recreating the table with the column compressed, or adding a column with compression and deleting the old column?

This example below does not work. Is there a way with ALTER or MODIFY?

     CREATE SET TABLE database1.TEST ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           AAA INTEGER,
           BBB INTEGER,
           CCC VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC
     PRIMARY INDEX ( A );

     ALTER TABLE database1.TEST ADD BBB COMPRESS 0;

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: 15 Jun 2023