Can't work out how to edit columns (SQLite)

[RottenBlock]

I'm not very experienced with databases, DBeaver, or SQLite, so maybe I'm missing something obvious here, but I can't seem to edit most of the details of the columns in my SQLite database? I can create new ones, delete old ones, and can rename the ones that are there, but can't otherwise edit the existing columns or reorganize them. Is that just the way it's supposed to work? I am using the Windows Community Edition.

Here are the steps I'm following:

1. Right Click -> Create New Connection
2. Select SQLite, Next
3. Open..., select the database file, Finish.
4. Open the Tables, select a table or create a new one.
5. I am in the Properties tab. The Columns are visible in the bottom right.
6. I am unable to drag and drop the columns, or check or uncheck Not Null or Auto Increment.
7. I double-click a column. Its details are displayed. I can edit the Column Name but not any other property.
8. I am able to create new columns or delete old ones by right-clicking. Until I commit my changes, I have full control over new column.

Notably, I found a bug report that sounds remarkably similar, but it claims to have been solved back in 2020.

#6373

Does anyone know what I'm overlooking?

[ged-yuko]

This apparently is because SQLite doesn't support ALTER COLUMN clause. At all. So there is no way for DBeaver to support editing operations there.

See its ALTER TABLE statement official documentation at https://www.sqlite.org/lang_altertable.html and ommitted features list at https://www.sqlite.org/omitted.html

There is even an explicit recommendation to do things in an obviously correct way like this:

[RottenBlock]

Huh, that's unusual, but if that's how it works, I guess I had better be careful when I set up my tables!