SQL Server Autocomplete
Posted: Thu Jan 28, 2016 2:12 pmHi
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.
-B
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
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.
-B
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