Re: [sqlite] Why can't SQLite drop columns?

On 10/8/12, Petite Abeille 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

Re: [sqlite] Why can't SQLite drop columns?

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

Re: [sqlite] GUI for SQLite

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

Re: [sqlite] Is there way to modify table structure after > initial definition ?

On 2/21/12, Andrew Barnes 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