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 used to
create the table in the first place. You can erad it like any other table.
Just copying a table won't recreate any indexes, constraints, triggers
etc which exist on that table.
You can create a table from the result of a select.
As a first attempt I'd do something like:
start transaction
get the table schema and that of any triggers etc
alter the schema to lose the unwanted column (in Delphi)
drop the triggers, indexes etc
rename the table you want to change
create new table with the new structure
copy the data from old table to new table
recreate the new triggers, indexes etc
end transaction
drop the old table
vacuum the database
NB: I haven't tried or tested the above. ;)
Martin
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
