Some freeware SQLite tools, such as SQLiteStudio, allow you to drop
columns (they do it by copying the table, but it's transparent to
you). If you don't need to drop the column programmatically, as part
of a bigger automated process, it works and you don't have to code
anything.
gs
On 10/8/12, Petite Abeille petite.abei...@gmail.com wrote:
How do they deal with constraints? triggers? indexes? others?
If this was as straightforward as a 'create table bar as select a, b, c from
foo; drop table foo; alter table bar rename to foo;', we would most likely
not having this
I've been happy with SQLite Studio:
http://sqlitestudio.one.pl/
One of the things I like about it is that it can do table edits not
supported by SQLite's ALTER TABLE -- it automatically creates a new
table and copies the existing data. Saves me a lot of effort. Other
SQLite managers may be
On 2/21/12, Andrew Barnes andyrbar...@hotmail.com wrote:
You need to study the ALTER TABLE statement and its limitations.
{snip}
SQLLite uses dynamic typing so you can put data of any type into any column.
Modification of the table structure might not be necessary in this
case, but in a general