SQLite Forum

Change column name
Login

Change column name

(1) By Hasdrubal on 2020-06-19 18:38:10

Hi.Is there a way to change an existing column name in a table? Have tried in DB Browser, but SQL is very new to me. Have looked on internet and came up with various 'how to's' but doesn't seem to fly.

How can I do this or where would I look to find out?

Thank you.

(2) By Warren Young (wyoung) on 2020-06-19 18:47:21 in reply to 1 [link]

[`ALTER TABLE RENAME COLUMN`](https://www.sqlite.org/lang_altertable.html#alter_table_rename_column)

(3) By Hasdrubal on 2020-06-19 21:08:32 in reply to 2 [link]

ok.

Will give it a whirl.

Thanks