How to delete table field in sqlite3?

Question

SQLite

How to delete table field in sqlite3?

Answer 1

sqlite does not support the ability to delete a table column directly. You can work around this:
1. make a new table with only the required columns
2. add data from the old table to it with

INSERT INTO new_table_name (v1, v2) SELECT v1, v2 FROM old_table_name

3. delete (or rename) the old table
4. rename the new table as the old table was named
https://www.sqlitetutorial.net/sqlite-alter-table/

Answer 2

1) Copy all the data to another table with a deleted column
2) Delete the main one, rename the new one
https://stackoverflow.com/a/8442173