SQLite Forum

How to remove a column and guide from the docs
Login
Hi. I'm trying to remove a column and add a different one instead. 

I've found a guide in docs and follow point 5 [Making Other Kinds Of Table Schema Changes](https://sqlite.org/lang_altertable.html#making_other_kinds_of_table_schema_changes).

I made a script that works when I execute it from CLI, but when I try to work with sqlite jdbc it fails with 

`A table in the database is locked (database table is locked)` 

on the "drop old table" line. 

Could you explain why is it and how to get it work from my app's db migration flow?