HELP ! Delete column in sqlite

General
1

Hi group, I can’t figure out how to delete an entire column from a table with sqlite.

2

Have-you looked at sqlite.com or SQL Tutorial ?

SQL Delete
SQL Update

Do you really want to delete a Column ?
Or Do you want to clear a Column contents ?

3

alter table mytable drop column mycol

See:

https://www.sqlite.org/lang_altertable.html

2 Likes
4

In fact, it depends on what is in your table(s).

If you are rewriting it, it means you can export and import the data (from the actual Acces to SQLite).
So, you better clear it off the SQLite file and start from the beginning (create a new SQLite file with the final structure, then import the (saved) data.
Do that until you are ok with the structure instead of lost your time modifying an existing but useless file (IMHO, your time).

5

if you speak about the structure
this can be done with sql or you use a database management tool.