Teradata ALTER TABLE DROP COLUMN

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;