Hello,

The ALTER TABLE page (http://www.sqlite.org/lang_altertable.html) states:

SQLite's version of the ALTER TABLE command allows the user to rename or add a new column to an existing table. It is not possible to remove a column from a table.

The RENAME TO syntax is used to rename the table identified by [database-name.]table-name to new-table-name. This command cannot be used to move a table between attached databases, only to rename a table within the same database.

Looking at the syntax, it looks like we can only rename the tables, not columns. Is it just a documentation error? Can we rename columns at all?

Thanks,

-- Tito

Reply via email to