delete column from table

[pishguy]

is any solution about deleting column from table?

[simolus3]

Same as #128 (comment), I'm afraid. There's no builtin support from sqlite for this, so you would need to do that manually.

[dvoloshyn]

@simolus3, Not sure when sqlite added it but it seems to support column dropping now: https://sqlite.org/lang_altertable.html#altertabdropcol
Is it possible to add the native support for this?
For now I'm using the following code:

const dropTargetValue = "ALTER TABLE items DROP COLUMN targetValue";
m.database.customStatement(dropTargetValue);

[simolus3]

DROP COLUMN was added in sqlite3 3.35.0, I've added a dropColumn method to the migrator API in 8427a18.