Default DB schema when editing code

Hi there,

 

So, I'm editing a piece of PHP code that includes a string which is actually a SQL query. PhpStorm is smart enough to offer me code completion while editing that SQL string. The thing is that I have multiple DB connections defined in the Database tool window. Which one of those is being used for code completion (if any)? How can I force PhpStorm to use a certain one?

 

Thank you.

2 comments
Comment actions Permalink

Hi there,

"Settings/Preferences | Languages & Frameworks | SQL Resolution Scopes"

https://www.jetbrains.com/help/phpstorm/2022.2/settings-languages-sql-resolution-scopes.html

 

0
Comment actions Permalink

This is awesome, more than I bargained for. Thank you!

0

Please sign in to leave a comment.