Page 1 of 1

switch off insert of db name by autocomplete

PostPosted: Thu Jun 18, 2015 8:57 am
by frankmusolf
can i switch off insert of database name as prefix for table name by autocomplete?

Re: switch off insert of db name by autocomplete

PostPosted: Mon Jul 20, 2015 5:43 pm
by plantron
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.