Alter table DROP column in Teradata

Drop a column in a table in Teradata

We can use ALTER TABLE command to drop a column from an existing table. The following conditions apply to dropping columns from a table

  • We cannot drop indexed columns from a table without first dropping the index on those columns.
  • When we drop a column, Teradata Database delete that column in every row in the given table.

Syntax for Drop a column

Example for drop a column in Teradata

Lets drop the Custmer last name column from a Customer table in Banking database using Alter table Drop column statement.