Rename a column in an existing table.

Syntax

Flow chart showing the syntax of the ALTER TABLE RENAME COLUMN keywords

Description

Renames a column in an existing table.

:::caution

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

:::

Example

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

  1. ALTER TABLE measurements RENAME COLUMN sensor TO hum_sensor_1;