SQL Prompt Column Picker greyed

SelliSelli Posts: 1 New member
Hello,

I have a SQL Prompt License and I use the Management Studio SQL Server 18.
My problem is that the columns which are in one table, they doesn´t appears. 

For example:
SELECT *
FROM dbo.Example 

I expect that all columns, which are in dbo.Example will appear.
Instead nothing appears. The column picker is also greyed. I can only choose "All Suggestions" and there are my snippets ore other suggestions.

What can I do to fix the problem?

Thank you!

Sorry about my english! :)

Best regards,
Selli



Answers

  • Hi Selli,

    Can you confirm the full version of your SQL Prompt?

    You may need to refresh the suggestions from time to time. Please go to SQL Prompt->Refresh suggestions. Then please try again.

    The column picker is enabled once the table is selected. 
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • whodiswhodis Posts: 1 New member
    I'm having the same problem. Tables Views Columns and Stored Procedures are greyed out. I have a license, I've enabled "List all database columns after a Select statement", I've refreshed suggestions, I've restarted machine... No prompts... Im on 10.15.1.12422 
Sign In or Register to comment.