TERADATA - Adding and dropping multiple fields

alter table DATABASE_NAME.TABLE_NAME

add FIELD1_NAME varchar(200) null

, add FIELD2_NAME varchar(200) null

;

  

alter table DATABASE_NAME.TABLE_NAME

drop FIELD1_NAME

,drop FIELD2_NAME

;