Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Modifying a Table> Adding a Column
View PDF

Adding a Column

Function

This statement is used to add one or more new columns to a table.

Syntax

1
 
ALTER TABLE [db_name.]table_name ADD COLUMNS (col_name1 col_type1 [COMMENT col_comment1], ...);

Precautions

None

Example

1
 
ALTER TABLE t1 ADD COLUMNS (column2 int, column3 string);
Parent topic: Modifying a Table