Alter table DROP column in Teradata

Contents

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.

ALTER TABLE <DB_Name.Table_Name> DROP <Column_Name>;

1	ALTER TABLE <DB_Name.Table_Name> DROP <Column_Name>;

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

ALTER TABLE Banking_DB.Customer DROP CustLastName;

1	ALTER TABLE Banking_DB.Customer DROP CustLastName;

Recommended Articles