Archives of the TeradataForum

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

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

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>>