arrow_backwardBack to SQLite code examples

SQLite Rename Column Example

How to rename a table column in SQLite
content_copyCopy
ALTER TABLE
  "users" RENAME COLUMN "last_name" TO "family_name"

Using Beekeeper Studio?

Beekeeper Studio is a free and open source database manager for Windows, Mac, and Linux.

This feature is baked right in, so there's no need to manually type SQL every time. Access column renaming by right-clicking on a table in the sidebar and clicking 'View Structure'.

Download Beekeeper Studio