Examples: Column Updates Using ALTER TABLE (Datalake Form) - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Add two columns

ALTER TABLE MyIceberg.MyDatabase.Tab1 
   ADD c3 INT NULL, 
   ADD count INTEGER NOT NULL;

Drop two columns

ALTER TABLE MyIceberg.MyDatabase.Tab1 
   DROP c3, 
   DROP c4;

Rename a column

ALTER TABLE MyIceberg.MyDatabase.Tab1 
   RENAME c2 TO count;

Make an existing column required

ALTER TABLE MyIceberg.MyDatabase.Tab1 
   MODIFY c3 NOT NULL;

Change column type

ALTER TABLE MyIceberg.MyDatabase.Tab1 
   MODIFY c3 VARCHAR(255);

Reorder the columns using AFTER

ALTER TABLE MyIceberg.MyDatabase.Tab1 ADD (c7,c8) AFTER c6;

Reorder the columns using BEFORE

ALTER TABLE MyIceberg.MyDatabase.Tab1 ADD (c7, c8) BEFORE c6;