[SOLVED] PhpStorm SQL code autocomplete

PhpStorm SQL code autocomplete

I have used PhpStorm 10, but recently they released a new version. In PhpStorm 10 it was very comfortable to autocomplete SQL code. I could start typing the column name and autocompletion continued my code.

At the new version (PhpStorm 2016.2.1) you have to start typing with the table prefix before column name, that is not very convenient.

Maybe someone knows how change this option, that I could start typing column name without the table prefix to autocomplete my SQL.

Solution

I solved the problem. You have to do following steps:

Press Alt+Ctrl+S or File -> Settings
Then you go to Languages & Frameworks and open SQL Dialects tab.
There will be your project File/Directory window and you have to change <Generic> dialect to your current project dialect. In my case, it is a MySQL dialect.