Re: [sqlite] The best way to delete a column ?

Stef Mientki wrote: I just read it's not possible to delete a column in an existing table. Now what would be the best way to remove the column indirect (from Delphi code), I've never needed to do this so the following are just hints. The special table "sqlite_master" contains the SQL that was

[sqlite] The best way to delete a column ?

hello, I just read it's not possible to delete a column in an existing table. Now what would be the best way to remove the column indirect (from Delphi code), would it be something like this: start transaction create new table with the same structure, but without the column to delete (how?)