SQLite Forum

RENAME COLUMN incomplete documentation
Login
THe documentation says "the column name is changed within the table definition".  Foreign key definitions are part of the "table definition".  Rather trivial to demonstrate.

```
sqlite> create table parent (id integer primary key, stuff1 text collate nocase unique);
sqlite> create table child (id integer primary key, pid integer not null references parent(id), stuff2);
sqlite> alter table parent rename column id to chickadee;
sqlite> .schema
CREATE TABLE parent (chickadee integer primary key, stuff1 text collate nocase unique);
CREATE TABLE child (id integer primary key, pid integer not null references parent(chickadee), stuff2);
```