Schema & suggestions

mp_

When my tables names are unqualified (without schema) , SQL Prompt suggestions do not work. I have to qualify my table names with the schema to get suggestions.

Native intellisense works with unqualified table names on SSMS installation without  SQL Prompt.

For my environment, unqualified table names are the best.

Thanks!

Dan B

Hi mp_

Thanks for posting on the Redgate forums.

When using the correct database SQL Prompt will suggest table names when entering something like 

SELECT * FROM .... 

Without me needing to specify the schema.

Does the database you're seeing this issue on have multiple schemas? Could you confirm the version of SQL Monitor you are running, please?

mp_

Hi...The database I'm using has the dbo schema plus another schema. When I connect via SSMS without SQL Prompt installed, intellisense works fine. But with SQL Prompt installed I have to preface the table with the schema to get the auto suggestions.

I'm not running SQL Monitor...just SQL Prompt, version 9.5.6.10002

Dan B

Testing with two schema's I still do get suggestions before specifying the schema. I've attached the screenshot of what I see on my test also with SQL Prompt 9.5.6.



Could you share what you are seeing vs what Intellisense shows you?

mp_

I see that as well, but once I select a table auto suggestions stop if no schema specified on the table name.  

Dan B

I think some screenshots of what you are/aren't seeing would really assist here as Prompt does suggest all the correct column names for me. If you would prefer you can send screenshots into support@red-gate.com

mp_

Here's what I'm seeing. When selecting the table i get suggestions:

Without the schema prefix, no suggestions for column names:

with the schema prefix i get suggestions for column names: