Rename a column in an existing table.
Syntax
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
.
ALTER TABLE measurements RENAME COLUMN sensor TO hum_sensor_1;