DROP a column in a table in Teradata

You can drop a column from a table with ALTER command.

Syntax:
ALTER TABLE tbl_name DROP column_name


Example:
/* Drop a column in teradata */
ALTER TABLE tbl_employee DROP EmpNo