SQLite Forum

RENAME COLUMN incomplete documentation
Login
I believe the [RENAME COLUMN](https://www.sqlite.org/lang_altertable.html) documentation is incomplete.

Currently, it reads:
 
>ALTER TABLE RENAME COLUMN   
>The RENAME COLUMN TO syntax changes the column-name of table table-name into new-column-name. The column name is changed both within the table definition itself and also within all indexes, triggers, and views that reference the column. If the column name change would result in a semantic ambiguity in a trigger or view, then the RENAME COLUMN fails with an error and no changes are applied.   

Issues:

1. RENAME COLUMN requires version 3.25 or later.  This is only clear from reading the Release History for [2018-09-15 (3.25.0)](https://www.sqlite.org/releaselog/3_25_0.html).

2. The doc mentions effects on "indexes, triggers, and views," but nothing about what happens if the renamed column is used as a foreign key.