SQL autocomplete is appending table name when selecting foreign key columns
Answered
Hello,
When I'm writing a query in the SQL console that involves columns that are present in several tables in a MySQL database, the autocomplete functonality is appending the table name, so I have to go back and erase it. I have tried to configure some settings, and I have tried the solutions posted here and here, but nothing seems to work.
A little bit of insight here would be much appreciated.
By the way, I'm using Pycharm 2019.2.4 proffesional edition.
Please sign in to leave a comment.
>the autocomplete functonality is appending the table name
Could you please clarify on an example so that we could reproduce the behaviour and provide some screenshots, that describe the problem? Which table is it - the one from the current select from clause or a different one?
Also please attach screenshot of SQL resolution scopes where the selected database and schema would be visible for the file/folder.