TERADATA - Adding and dropping a field

alter table DATABASE_NAME.TABLE_NAME

add FIELD_NAME varchar(200) null

;

alter table DATABASE_NAME.TABLE_NAME

drop FIELD_NAME

;