How to Rename a Column in SQLite
This example renames the column my_column to my_renamed_column:
ALTER TABLE my_table
RENAME COLUMN my_column TO my_renamed_column;The ALTER TABLE statement is available since SQLite version 3.25.0.
This example renames the column my_column to my_renamed_column:
ALTER TABLE my_table
RENAME COLUMN my_column TO my_renamed_column;The ALTER TABLE statement is available since SQLite version 3.25.0.
DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.