#254 Cannot change columns for existing table

[Detlev Richter]

There is no possibility to change an existing table in sqlite(3 I did not test sqlite2). When I'm trying to edit the table definition no columns are displayed. In MySQL this function works like a charm.

PDO SQLite:
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z sebastian $
SQLite Library 3.3.7

SQLite-support
PECL Module version 2.0-dev $Id: sqlite.c 298697 2010-04-28 12:10:10Z iliaa $
SQLite Library 2.8.17
SQLite Encoding iso8859

btw: really nice piece of work!

[Detlev Richter]

top: table-structure; bottom: change table dialog

[Jakub Vrána]

SQLite doesn't support altering columns, only adding them.

Dropping old table and recreating it would be dangerous as there can be other objects related to it.