17.05 - Example: Changing NO COMPRESS for an Existing Column - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following example alters a column named qty_shipped_2006 in the customer table and makes that column uncompressible using multivalue compression. The column qty_shipped must already be defined for customer because you do not specify a data type for it. In that case, Vantage interprets the ADD specification to represent a request to modify an existing column.

     ALTER TABLE customer ADD qty_shipped_2006 NO COMPRESS;