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 | 

RENAME COLUMN Clause

Description 

You can change the name of the column by using the RENAME COLUMN clause.

Syntax

ALTER [ TABLE | CLASS | VCLASS | VIEW ] table_name

RENAME [ COLUMN | ATTRIBUTE ] old_column_name { AS | TO } new_column_name

  • table_name: Specifies the name of a table that has a column to be renamed.
  • old_column_name: Specifies the name of a column.
  • new_column_name: Specifies a new column name after the AS keyword.
Example

ALTER TABLE a_tbl RENAME COLUMN name AS name1;