Page 1 of 1

SQL Server Autocomplete

PostPosted: Thu Jan 28, 2016 2:12 pm
by bwilson

Im a new user of dbeaver, so my issue may just be a lack of knowledge on my part. Im using vers 3.5.8 and connecting to a MS Sqlserver 2008 instance.

When I use the database navigator to view the columns on a table I only see a subset of the possible columns. Similarly when autocomplete is invoked on a subset of the completes are displayed.

The account I'm an using has readonly privs. However, Im able to query information_schema w/o issue which returns full column complement.


Just noticed that it appears to only show columns where domain_catalog = null in the information_schema table:

select column_name
from information_schema.columns c
where table_name = 'MYTABLE'
and domain_catalog is null