switch off insert of db name by autocomplete

Feature requests and their debate

switch off insert of db name by autocomplete

Postby frankmusolf » Thu Jun 18, 2015 8:57 am

can i switch off insert of database name as prefix for table name by autocomplete?
Posts: 34
Joined: Thu Jul 04, 2013 6:07 am

Re: switch off insert of db name by autocomplete

Postby plantron » Mon Jul 20, 2015 5:43 pm

This is a somewhat new behavior in dBeaver, perhaps since version 3.0?

If I have several databases with the same structure (same table names, table column names, etc.), and I use autocomplete in my query, it suggests all the tables that starts with the string in all databases.

For example, I have 10 databases with names db01, db02, db03,... db10. In each of these databases, I have tables user, product, salary. Now if I activate database db01 and begins typing "select * from u", and then Ctrl-Space, it will suggest everything from 'db01.user' to 'db10.user'. Many times the 'db01.user' option is not even the top option, so you have to scroll down with arrow keys to get to 'db01.user'. However, this should be obvious because in the vast majority of cases, I don't want to select or cross join with another database's table.
Posts: 4
Joined: Wed Jun 24, 2015 1:26 pm

Return to Feature Requests

Who is online

Users browsing this forum: No registered users and 5 guests