Shared by xexr

Renaming a column in planetscale

9 tasks

Your own copy to tick off. Free to get started.

Expand

Filters:

add new column with the new name and same type as the existing column

deploy dev branch to main on planetscale

copy data in existing column to the new column with raw SQL

update application code to use new column name

delete existing column and any indexes it is used in (making a note of the indexes)

add back any indexes with the new column

add back any needed constraints back to the new column (e.g. NOT NULL)

reorder columns back to original order if required

deploy dev branch to main on planetscale

9 tasks