Examples: Column-Level Alterations - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Example: Add Column to Table

ALTER FOREIGN TABLE ParquetTab1 ADD GageHeight FLOAT;

Example: Change Character Set of Payload Column to Unicode

ALTER FOREIGN TABLE JSONTab1
ADD Payload JSON(8388096) INLINE LENGTH 32000 CHARACTER SET UNICODE;

Example: Change Character Set of Payload Column to LATIN

ALTER FOREIGN TABLE JSONTab1 
ADD Payload JSON(16776192) INLINE LENGTH 64000 CHARACTER SET LATIN;

Example: Drop Column from Table

ALTER FOREIGN TABLE ParquetTab1 DROP GageHeight;