Warm tip: This article is reproduced from serverfault.com, please click

Default SQL Server Session for Intellij

发布于 2020-11-25 08:02:24

When opening a .bdy(/sql/vew/..)-File in IntelliJ, it always greets me with semantic errors for almost every line. That is because it needs a dbsession to check the references against. DataGrip behaves identical.

For reference:

enter image description here

Can I somehow state a default here per file/dir/proj/global?

Questioner
midorlo
Viewed
0
Yuri Win 2020-11-25 22:23:17

It's in File | Settings | Languages & Frameworks | SQL Resolution Scopes, here you can specify global Project Mapping to data source/database/schema, or define mapping for any directory/file. in DataGrip setting path will be as follow File | Settings | Database | SQL Resolution Scopes.