Rename a column

sql

ALTER TABLE app_users RENAME COLUMN display_name TO full_name;

Explanation

Modern SQLite supports renaming columns directly, which simplifies many migrations.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Change schemas safely

Append a new nullable or defaulted column.

Open In sheetsqlsame section

Change the table name without recreating data.

Open In sheetsqlsame section

Canonical pattern for dropping constraints or changing types.

Open In sheetsqlsame section

Define a rowid-backed table with primary key and timestamps.

Open In sheetsql1 tag match

Validate allowed values at the database layer.

Open In sheetsql1 tag match

Reference a parent table from a child table.

Open In sheetsql1 tag match