I'm connected to my universities' SQL Server (Microsoft driver). I've tried using both DataGrip from JetBrains and DBeaver to connect. Everything seems to be fine when I execute a query. However, neither DataGrip nor DBeaver is giving me help with table or column names. In fact, DataGrip keeps telling me "Unable to resolve..." even if I type in the whole name (as I said the query executes just fine). Example screenshot:
I'll be really grateful for any suggestions.
2条答案
按热度按时间siv3szwd1#
This issue is related to DataGrip's intellisense, a similar issue was posted to IntelliJ's community forms here .
This answer relates to DataGrip 2017.1.5 (is likely applicable to other versions as well):
After creating the initial connection to your server, open the Database tool window using:
(ALT + F1) or
(View -> Tool Windows -> Database).
Listed beneath your server connection you will see a "Schemas..." item, double click it. This will expand into a list of all DB schemas you have access to on that server.
Select the schemas you are interested in, and additionally expand each DB schema to select all child schemas for that DB.
Click the refresh button in the schema selection window to synchronize your settings (two arrows pointing at each other in a circle).
Image of Database Toolbar with DB/Schema selection
eqzww0vc2#
If they are DBO owned tables, qualify then as dbo.MyTable. Datagrip seems to want a schema (DBO) for objects in order to use intellisense.