DROP COLUMN Clause

Description

You can delete a column in a table by using the DROP COLUMN clause. You can specify multiple columns to delete simultaneously by separating them with commas (,).

Syntax

ALTER [ TABLE | CLASS | VCLASS | VIEW ] table_name

DROP [ COLUMN | ATTRIBUTE ] column_name, ...

Example

ALTER TABLE a_tbl DROP COLUMN age1,age2,age3;