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
- [sqlite] ALTER TABLE: Confusing documentation Tito Ciuro
-