Moving colums in table columns editor

[lorenzo-s]

Can't get how to move table colums up and down, both when editing columns definition or creating a new one. I see there is an "Ordinal position" field, but it's uneditable!

[Serge]

Hi,

There is no way to change column's ordinal position. Actually it is not supported by SQL standard and by most database vendors.
There are various database-dependent workarounds and most of them require table recreation - and of course this solution can't be used as general approach.

So, DBeaver doesn't support this feature. Probably we'll add it for particular databases (e.g. Oracle) in future. But it is quite hard to implement so I don't think such feature will appear in one of nearest versions.

Thanks.

[lorenzo-s]

In MySQL you can change column order any time you want. It's strange to not have this feature in a DB administration tool. For the moment I will do it via ALTER query.

[Serge]

Ah, yes. MySQL probably the only popular database which supports this. I forgot about their tricky metadata handling)
Maybe we'll implement this feature for MySQL first as it pretty simple.

If we'd talk about databases in general then there are hundreds of very usefull features.
But as DBeaver is universal tool we implement universal features first. For now database specific features are implemented only if it is relatively easy to do. And this feature is not (at least it requires some model change and general UI for columns reorder).

But anyway, I'll add it in TODO list.