Highlight SQL queries in PHPStorm


Connected to a database in PHPStorm. The connection was successful.

The structure of my tables is now displayed in the Database tab (View -> Tool Windows -> Database).

However, all my SQL queries are highlighted in yellow and the tables and columns are highlighted in red. The IDE refers to the fact that there are no such tables and columns and suggests creating. But in the Database tab, these same tables and columns are.

Tell me how to remove this highlighting in yellow and what to do so that the IDE determines tables and columns inside SQL queries?





1 comment
Comment actions Permalink

Please open File | Settings | Languages & Frameworks | SQL Resolution Scopes and check that the project is mapped to a required scheme, not "All sources":

Then open File | Settings | Languages & Frameworks | SQL Dialects and set correct SQL dialect. If you're using MariaDB - please select it, not just MySQL.


Please sign in to leave a comment.