Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

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, ...

  • table_name: Specifies the name of a table that has a column to be deleted.
  • column_ name: Specifies the name of a column to be deleted. Multiple columns can be specified by separating them with commas (,).
Example

ALTER TABLE a_tbl DROP COLUMN age1,age2,age3;