Moving colums in table columns editor

Note: please leave bug reports and feature requests on

Moving colums in table columns editor

Postby lorenzo-s » Tue Aug 28, 2012 7:43 am

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! :|
lorenzo-s
 
Posts: 6
Joined: Sun Aug 26, 2012 2:31 pm

Re: Moving colums in table columns editor

Postby Serge » Tue Aug 28, 2012 7:53 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Moving colums in table columns editor

Postby lorenzo-s » Tue Aug 28, 2012 8:35 am

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.
lorenzo-s
 
Posts: 6
Joined: Sun Aug 26, 2012 2:31 pm

Re: Moving colums in table columns editor

Postby Serge » Tue Aug 28, 2012 8:56 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 8 guests