SQL Server DataGrip / DBeaver cannot resolve table / column names

pcww981p  于 2023-10-15  发布在  其他
关注(0)|答案(2)|浏览(124)

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.

siv3szwd

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

eqzww0vc

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.

相关问题