Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#254 Cannot change columns for existing table

3.3.4
closed-wont-fix
Jakub Vrána
SQLite (25)
5
2012-06-29
2012-06-27
Detlev Richter
No

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!

Discussion

  • Detlev Richter
    Detlev Richter
    2012-06-27

    top: table-structure; bottom: change table dialog

     
    Attachments
  • Jakub Vrána
    Jakub Vrána
    2012-06-29

    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.

     
  • Jakub Vrána
    Jakub Vrána
    2012-06-29

    • status: open --> closed-wont-fix