Code Completion and Schemas

Answered

I am using Datagrip with SQL Server. As I type into a console window, code completion only searches the dbo schema and not other schemas in the database. So if I have an GeneralLedger table in the Accounting schema and I type:

SELECT *

FROM Gene

I don't get the GeneralLedger table in the code completion window because it is in the Accounting schema, not the dbo schema.

Is there a way to configure Datagrip to search all schemas when I type in the console?

 

4 comments
Comment actions Permalink

Hello, you always have to specify schema name for any object which is not in 'dbo'. Completion will show you schema name when you put it's first letter and then you will see table names here.

0
Comment actions Permalink

I am experiencing the same issue as Mbricker. I think having to specify the schema name first defeats the whole purpose of code completion. I don't want to have to remember the schema name, I know I'm looking for a particular table, it should autocomplete tables in all schemas, and auto fully qualify it as we select it.

Other tools, for example, Redgate's SQL Prompt autocompletes without having to specify the schema. When you have a large database, part of the reason you want to use code completion is to not have to remember all the schema names to input them first. 

1
Comment actions Permalink

Here is the issue on our tracker.

0
Comment actions Permalink

agree. We've got like two dozens different schemas and remembering all of them is really painful

0

Please sign in to leave a comment.