ALTER TABLE RENAME COLUMN

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:

Renaming a column

ALTER TABLE measurements RENAME COLUMN sensor TO hum_sensor_1;