Schema & suggestions

• 
  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?

  Dan B June 12, 2019 10:31

  - 0 +
• 

  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
  

  mp_ June 12, 2019 14:24

  - 0 +
• 
  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?
  
  
  

  Dan B June 12, 2019 15:27

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

  mp_ June 12, 2019 16:08

  - 0 +
• 
  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
  
  

  Dan B June 13, 2019 08:19

  - 0 +
• 
  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:

  
  

  
  

  mp_ June 13, 2019 17:36

  - 0 +

Add comment

Please sign in to leave a comment.