SQL Server Code completion does not include schema name
Answered
Brand new to Datagrip:
If I have a Microsoft SQL Server connection, and I have ATable in schema ASchema, as I start writing the query "select * from", I get a code-completion prompt to select ATable (good), but if I hit TAB to select it, Datagrip does not include the schema name, so I end up with "select * from ATable". In order for the query to run successfully, it needs to be "select * from ASchema.ATable".
Is there a setting somewhere to enable this behavior? Without it, code completion for SQL server just isn't very useful I'm afraid.
Please sign in to leave a comment.
See the settings under Preferences | Editor | General | Code Completion
I'm on a Mac with version 2025.3.2 (Build #IU-253.30387.90) (IntelliJ IDEA Ultimate) and this is still an issue for me. MS SQL Server with the above ("Schema") set to “Always”, I never get the schema included in code completion when I select a table. Is there something else I need to set?
Hi Robert,
In addition to the option mentioned above, please ensure you have the Basic Completion enabled
Bingo! Thank you!