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?)
copy the data from old table to new table
delete the old table
rename the new table to the old name
vacuum-clean the database
end transaction
I this the best way, or are there any other ?
Sorry I'm just starting SQL, so I just used human SQL.
(and therefor a complete code section would be welcome ;-)
thanks,
Stef Mientki
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------