You can use ALTER TABLE drop column statement to drop an existing column from a Teradata table.
Teradata ALTER TABLE DROP COLUMN Syntax
The syntax of Teradata ALTER TABLE DROP COLUMN is as below.
ALTER TABLE database_name.tbl_name DROP column_name;
Teradata ALTER TABLE DROP COLUMN Example
The below example drops the Hobbies column from the employee table.
ALTER TABLE Teradatapoint.employee DROP hobbies;