Back to Questdb

ALTER TABLE RENAME COLUMN

documentation/query/sql/alter-table-rename-column.md

latest602 B
Original Source

Rename a column in an existing table.

:::caution

  • New column names may only consist of letters, numbers and underscores _

:::

Syntax

Example

The following example renames an existing column called sensor to hum_sensor_1 from the table measurements:

questdb-sql
ALTER TABLE measurements RENAME COLUMN sensor TO hum_sensor_1;