ADD COLUMN (column_name) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Add the column set as a new column partition. 
For information about naming database objects, see Object Names.
The table must be column-partitioned and the columns being added cannot already exist. You cannot alter a join index to add columns or column partitions using an ALTER TABLE request. Specifies column storage format for the column_name or column_name group. Alters the column partition containing the column to have COLUMN format. If you do not specify COLUMN, ROW, or SYSTEM format and the column partition containing the column:
  • Does not have a system-determined format, the column partition is not altered and the format remains as most recently defined.
  • Has a system-determined format, the format remains system-defined.

    If the altered column partition containing the column has a system-determined column partition format, the column partition is altered to a newly appropriate format.

data type
Data type for the column.
column attributes
Specify attributes for the column.
AUTO COMPRESS
Autocompress data in the column.
NO AUTO COMPRESS
Do not autocompress data in the column.