Schema Changes

Rename a Column

Rename the copied column after the data is present.

highlighted = computed this step

Rename a column

A rename changes the column label while keeping the copied values.

rename label\text{rename label}

Show the rename

The migration has 4 steps and 4 columns after the rename.

steps=4\text{steps}=4

Schema-change examples are tiny finite table transforms; SQL dialects, online migration algorithms, locks, performance, ORMs, compliance, and operational runbooks are out of scope.

Rename a column: beforeidname1Ada2Bo ordered schema stepsstepop1add_column_default2backfill_column3copy_column4rename_column step snapshotsstepopcolumnsrows0start[id, name]21add_column_default[id, name, age]22backfill_column[id, name, age]23copy_column[id, name, age, label]24rename_column[id, name, age, display_name]2 final tableidnameagedisplay_name1Ada37Ada2Bo29Bo changed columnskindcolumnsadded[age, display_name]removed[]kept[id, name] changed rowsrowbeforeafter0[1, Ada][1, Ada, 37, Ada]1[2, Bo][2, Bo, 29, Bo] safety factsfactvaluestepCount4rowCount2columnCount4changedRowCount2

Read the final labels

The final table shows the copied column under its new name.

new label visible\text{new label visible}

Summary

This is a table-shape transform, not a vendor-specific rename command.

label transform\text{label transform}