15.00 - Adding, Modifying, or Dropping Block-Level Compression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Adding, Modifying, or Dropping Block-Level Compression

You cannot add, modify, or drop the block-level compression characteristics of a table or join index using ALTER TABLE requests. You must use the Ferret utility (see Utilities: Volume 1 (A-K)) to change the block-level compression of a table or join index. See “Block‑Level Compression and Tables” on page 509 for a brief description of the restrictions on specifying block-level compression for volatile and global temporary tables.